sqlserver 类似oracle的rownum功能： row_number
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
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
