从DB里提取钱几条记录的语句

最新推荐文章于 2021-08-17 08:36:09 发布

enshilove

最新推荐文章于 2021-08-17 08:36:09 发布

阅读量127

点赞数

分类专栏： Oralce 文章标签： Sybase Oracle DB2 Informix MySQL

本文链接：https://blog.csdn.net/enshilove/article/details/83495938

版权

Oralce 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

数据库取前几条记录的语句
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