中间行纪录的取得方法

1.取前10行

    oracle:  select * from xxx where rownum<10

    mysql:   select * from xxx limit 10

 

2.取中间10000~10010行

    oracle:  select * from (select rownum r, a.* from xxx a where rownum<=10010 ) where r >=10000

    mysql:  select * from xxx where vid >=(select vid from xxx order by vid limit 10000,1) limit 10

    // 上面的做法比单纯的select * from xxx limit 10000,10效率高