select ROW_NUMBER() OVER (order by ID desc) as ID,* from 表名 转载于:https://www.cnblogs.com/liushunli/p/4025635.html