2008-07-07
数据库取前几条记录的语句總結
关键字: 数据库
数据库取前几条记录的语句
1. ORACLE
SELECT * FROM TABLE1 WHERE ROWNUM<=N
2. INFORMIX
SELECT FIRST N * FROM TABLE1 where 1=1
3. DB2
SELECT * ROW_NUMBER() OVER(ORDER BY COL1 DESC) AS ROWNUM WHERE ROWNUM<=N
或者
SELECT COLUMN FROM TABLE where 1=1 FETCH FIRST N ROWS ONLY
4. SQL SERVER
SELECT TOP N * FROM TABLE1 where 1=1
or
SET ROWCOUNT N SELECT * FROM TABLE1 where 1=1 SET ROWCOUNT N1
5. SYBASE
SET ROWCOUNT N SELECT * FROM TABLE1 where 1=1 SET ROWCOUNT N1
6. MYSQL
SELECT * FROM TABLE1 where 1=1 LIMIT N
7. FOXPRO
SELECT * TOP N FROM TABLE ORDER BY COLUMN
8. ACCESS
SELECT TOP N * FROM TABLE1 where 1=1
1. ORACLE
SELECT * FROM TABLE1 WHERE ROWNUM<=N
2. INFORMIX
SELECT FIRST N * FROM TABLE1 where 1=1
3. DB2
SELECT * ROW_NUMBER() OVER(ORDER BY COL1 DESC) AS ROWNUM WHERE ROWNUM<=N
或者
SELECT COLUMN FROM TABLE where 1=1 FETCH FIRST N ROWS ONLY
4. SQL SERVER
SELECT TOP N * FROM TABLE1 where 1=1
or
SET ROWCOUNT N SELECT * FROM TABLE1 where 1=1 SET ROWCOUNT N1
5. SYBASE
SET ROWCOUNT N SELECT * FROM TABLE1 where 1=1 SET ROWCOUNT N1
6. MYSQL
SELECT * FROM TABLE1 where 1=1 LIMIT N
7. FOXPRO
SELECT * TOP N FROM TABLE ORDER BY COLUMN
8. ACCESS
SELECT TOP N * FROM TABLE1 where 1=1
发表评论
morris
- 浏览: 43794 次
- 性别:
- 来自: 深圳
- 详细资料
搜索本博客
最新评论
-
美国梦八夺冠已成定局了！
梦八队员的运动能力太强了，抢断和快攻水平一流，往往能在某一段时间打出小高潮，把比 ...
-- by suyulin6688 -
美国梦八夺冠已成定局了！
robbin 写道keshin 写道robbin 写道美国就快攻一招鲜，如果碰上 ...
-- by keshin -
美国梦八夺冠已成定局了！
keshin 写道robbin 写道美国就快攻一招鲜，如果碰上实力强劲，内线有高 ...
-- by robbin -
美国梦八夺冠已成定局了！
keshin 写道robbin 写道美国就快攻一招鲜，如果碰上实力强劲，内线有高 ...
-- by zxpole -
美国梦八夺冠已成定局了！
robbin 写道美国就快攻一招鲜，如果碰上实力强劲，内线有高度，外线防守又好的 ...
-- by keshin
评论排行榜