SQL Server 获取表中各分组的第一条数据

SELECT * FROM (SELECT ROW_NUMBER() OVER(PARTITION BY GroupID ORDER BY GroupID) ID,* FROM tab_Users) NEWTABLE WHERE ID = 1

原文地址:https://www.cnblogs.com/chensp/p/3333289.html