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
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