• 欢迎@方程式 @小云 加入我们
  • Register

各数据库读取前10条记录的SQL语句

纯记录,不解释!

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
版权声明:转载请注明来自杨俊伟博客,本文地址:http://yangjunwei.com/a/68.html
除非注明,杨俊伟博客文章均为原创,转载请注明出处和链接!
 

沙发木了,占个板凳也不错~ »

发表评论 

我还是想用邮箱注册

登录

忘记密码 ?

用第三方帐号快捷登录

已有账户?前往登录吧~

注册