select row_number()over(order by columnname)as rownum,* from tablename 按照columnname列进行排列 转载于:https://www.cnblogs.com/wuhailong/p/4015929.html