SELECT *
FROM
(
SELECT
ROW_NUMBER() OVER (PARTITION BY L.ID ORDER BY l.ID) AS List_INDEX,
L.*
from table L
) T
WHERE T.List_INDEX=1
ROW_NUMBER() OVER (PARTITION BY L.ID ORDER BY l.ID) 意思是 根据ID进行分组后进行排序,并给排序后的数据加上序号
SELECT *
FROM
(
SELECT
ROW_NUMBER() OVER (PARTITION BY L.ID ORDER BY l.ID) AS List_INDEX,
L.*
from table L
) T
WHERE T.List_INDEX=1
ROW_NUMBER() OVER (PARTITION BY L.ID ORDER BY l.ID) 意思是 根据ID进行分组后进行排序,并给排序后的数据加上序号