How to find the rows from a table which has exactly two 'n' s in the employee name?

Question

I want to find all the employees whose names have exactly two n's in their name. How can this be done?

Answer 1

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 :-)