效果如下: 语句: SELECT ROW_NUMBER() OVER ( ORDER BY XX ASC ) AS ID,... 转载于:https://www.cnblogs.com/pfs1314/archive/2011/02/16/1955755.html