rownum

SELECT   ( 
SELECT   count(*)+1   as   行号   
FROM   成绩表   as   a     where   a.实际成绩> b.实际成绩)   AS   rownum,   b.实际成绩 
FROM   成绩表   as   b   order   by   b.实际成绩   desc

select count(*),b.id from fin_account as a, fin_account as b
where a.id<=b.id
group by b.id
order by b.id asc