sql -如果记录是重复集中的一个，则首先记录

After this SQL Query:

在这个SQL查询:

SELECT DISTINCT * 
    FROM ['Duplicate Data$']
    WHERE Name in
    (
        SELECT Name
        FROM ['Duplicate Data$']
        GROUP BY Name
        HAVING COUNT(*)>1
    )
    ORDER BY Name
SELECT DIST