Find duplicate of last name

Hello eveyone,

How can I query to find and list the duplicates of any last name in a database.

Thanks and regards,
Anna.

e.g

select Name, count(*) from TABLE group by Name having count(*) > 1

Janet