How to find the rows from a table which has exactly two 'n' s in the employee name?
something like this should be enough:

select * from employee_table where Length(lastname) - length(replace(lastname, 'n','')) = 2


be aware that may cause a full table scan :-)