表按某个字段,新增一个序号列 表按某个字段,新增一个序号列(1,2,3,4,5...) select Row_Number() Over (Order by T.XXdatetime) as Sql, T.* from XXtable T PS:适合Sql Server & Oracle