sqlserver 类似oracle的rownum功能： row_number
本站寻求有缘人接手，详细了解请联系站长QQ1493399855
select row_number() over(order by t.id ) as num,id,name from (
SELECT distinct [列 0] as id
,[列 1] as name
FROM MonitorSetup --order by [列 0]
)t
本站寻求有缘人接手，详细了解请联系站长QQ1493399855
select row_number() over(order by t.id ) as num,id,name from (
SELECT distinct [列 0] as id
,[列 1] as name
FROM MonitorSetup --order by [列 0]
)t