Oracle數(shù)據(jù)庫寫法：
--查詢第5-10條記錄
方式一：
select * from (select rownum myrow,t.* from efb_random_pwd t) where myrow between 5 and 10;
以下兩種方式數(shù)據(jù)量大的時候效率好些。
方式二：
select * from (select rownum r,a.* from efb_random_pwd a where rownum<=20) where r>=10;
方式三：
select * from efb_random_pwd where rowid in(
select rid from (select rownum num,rowid rid from efb_random_pwd a where rownum <=10) where num > = 5);
MySql數(shù)據(jù)庫寫法：
select * from tablename where LIMIT 9,10
從10條開始取，取10條，則就是10--20
SqlServer數(shù)據(jù)庫寫法：
1:select top 20 * from tablename where id not exists (select top 10 * from tablename)//前20條記錄再過濾掉前10條
2:select top10 * from (select top 20 * from order by column) order by column desc//子查詢中取20條倒序，然后從子查詢中取前10條
posted on 2011-01-20 13:33
David1228 閱讀(189)
評論(0) 編輯 收藏