How to find duplicate rows in a table using sql queries.

Here is the example.

SELECT [uid]     FROM [People]      WHERE [Name] IN (    SELECT [Name]    FROM [People]    GROUP BY [Name]    HAVING 
( COUNT([Name]) > 1 ))