limit和rownum
class中成绩的第10-20名从小到大排序。 MySQL：select * from class where order by limit 9,10; Oracle：select * from class where 10<rownum<=20 order by score； MySQL中limit用法：select * from table limit m,n （其中m是指记录开始的in
