[RESOLVED] Finding duplicate values in a DB Table?

[blakemckenna]

I always forget how to do this but I'm trying to write a SQL query that identifies a specific column per row that has duplicate values. In other words, there may be 5 rows where the LastName has the same value. How do I write a query that will return only those rows?

Thanks,