--sql 2000
select 序號(hào) = (select count(1) from tb where 學(xué)號(hào) < t.學(xué)號(hào)) + 1,學(xué)號(hào) ,姓名 from tb t

 
--sql 2005
select 序號(hào) = row_number() over(order by 學(xué)號(hào)),學(xué)號(hào) ,姓名 from tb

 
--oracle
select row_number() over(order by 學(xué)號(hào)) 序號(hào),學(xué)號(hào) ,姓名 from tb
--postsql
SELECT ROW_NUMBER () OVER ( ORDER BY A0 DESC,B0 DESC,C0 DESC ) AS rid ,* FROM t_road WHERE A0 = 'X' ORDER BY A0, B0,C0 ;