怎么把查询出来的数据编号？

[modou]

比如我查询出来20个结果，我想把这20个结果从1到20编号作为一列，该怎么做？

[pengdali]

select IDENTITY(int, 1,1) AS ID_Num,* into #temp from 表



select * from #temp where ID_Num

[caiyunxia]

select top 20 IDENTITY(int, 1,1) AS ID_Num,* into #temp from 表
select * from #temp where ID_Num

[modou]

谢谢，结帖了。