SQL Server 获取表中各分组的第一条数据 SELECT * FROM (SELECT ROW_NUMBER() OVER(PARTITION BY GroupID ORDER BY GroupID) ID,* FROM tab_Users) NEWTABLE WHERE ID = 1