oracle ROW_NUMBER 和 ROWNUM 

select row_number () over (order by rownum desc) as rn,rownum,aaa from aaaa
/

　　

posted @ 2011-08-15 17:54  庚武  Views(221)  Comments(0)  Edit  收藏  举报