SQL语句排序的记录顺序号？
请问怎样可以得到SQL语句查询时的记录编号：
例如：select top 10 id,name from program order by id
怎么可以可到第一条记录的编号是1，第二条的记录编号是2 …… 第十条的记录编号是10，先谢谢啦！
[解决办法]
SELECT ROW_NUMBER() OVER(ORDER BY ID ) AS 'Row Number ',ID,NAME
FROM program
[解决办法]
select top 10 BH=indentity(int,1),id,name into #t from program order by id
select * from #t
drop table #t
[解决办法]
Sorry,更正下,indentity(int,1,1),上面的少了个 ",1 "
select top 10 BH=indentity(int,1,1),id,name into #t from program order by id
select * from #t
drop table #t
[解决办法]
--如果 id 唯一
SELECT TOP 10
(SELECT COUNT(*)
FROM program
WHERE a.id > = id) AS 编号, id,name
FROM program as a
ORDER BY id
[解决办法]
一楼的仁兄说的是2005的用法！2000没有！
