sql - 第一个记录(如果该记录是重复集中的一个)

Question

执行此 SQL 查询后:

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

我的表格如下所示:

    ID | Name
  20215 | A Abbott
  22015 | A Abbott
  11825 | A Albert
  20745 | A Albert
  14109 | A Allan
  19696 | A Allan
  13133 | A Allan
  17311 | A Allen

我需要查询该表，以便返回结果，如下所示:

     ID | Name
  20215 | A Abbott
  11825 | A Albert
  13133 | A Allan

Answer 1

    SELECT MIN(ID),Name
    FROM ['Duplicate Data$']
    GROUP BY Name
    HAVING COUNT(*)>1
    ORDER BY Name