Find duplicates - Unique IDs

[skhanal]

You can do

select lastname, firstname, count(*)
from table
group by lastname, firstname
having count(*)>1