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