SELECT ROW_NUMBER() over ( order by 字段) from 表 转载于:https://www.cnblogs.com/zhangyong0908/p/9415863.html