亚洲av日韩综合一区在线观看,亚洲最新永久在线观看,亚洲va无码专区国产乱码

常見數(shù)據(jù)庫(kù)的分頁(yè)語(yǔ)句

1、oracle
2

select * from (select a.*,rownum row_num from (select * from jobs t where job_desc like '%a%' order by t.job_id desc) a) b where b.row_num>=1 and b.row_num<=5;
3

2、mysql
4

select * from jobs where job_desc like '%a%' order by t.job_id desc limit 1,5;
5

3、db2
6

select * from (select rownumber() over(order by t.job_id desc) as rowNum,t.* from jobs as t where job_desc like '%a%' order by t.job_id desc) as res where res.rowNum between 1 and 5;
7

4、sqlserver2005
8

select * from (select *,row_number() over(order by job_id desc) as rowNum from jobs where job_desc like '%a%')as t where t.rowNum between 1 and 5;
9

5、sqlserver2000
10

select top 5 * from jobs where jobs_id not in (select top 5 jobs_id from jobs order by jobs_id desc) where job_desc like '%a%' order by jobs_id desc desc;
11

6、access
12

select top 5 * from jobs where jobs_id not in (select top 5 jobs_id from jobs order by jobs_id desc) where job_desc like '%a%' order by jobs_id desc desc;
13

注意acess沒有top 0
14

7、postgre
15

select * from jobs limit 10 offset 0;
16

offset 偏移量 0表示從第一條開始
17

limit 共取幾條 10表示本次查詢10

posted on 2010-11-02 22:00 麟德閱讀(263) 評(píng)論(0) 編輯收藏所屬分類: oracle

新用戶注冊(cè) 刷新評(píng)論列表


只有注冊(cè)用戶登錄后才能發(fā)表評(píng)論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關(guān)文章: 常見數(shù)據(jù)庫(kù)的分頁(yè)語(yǔ)句查看oracle數(shù)據(jù)庫(kù)的連接數(shù)以及用戶 oracle用戶授所有權(quán)限 oracle中創(chuàng)建用戶和表創(chuàng)建表空間、用戶、用戶授權(quán) oralce 數(shù)據(jù)庫(kù)備份與還原

常見數(shù)據(jù)庫(kù)的分頁(yè)語(yǔ)句

導(dǎo)航

統(tǒng)計(jì)

常用鏈接

留言簿

隨筆分類(2)

隨筆檔案(2)

文章分類(23)

文章檔案(23)

最新隨筆

搜索

積分與排名

最新評(píng)論

閱讀排行榜

評(píng)論排行榜