mysql命令查询表内前10行数据库_各数据库查询前N行的数据SQL

1. Oracle数据库

SELECT * FROM TABLENAME WHERE ROWNUM <= N

2. Infomix数据库

SELECT FIRST N * FROM TABLENAME

3. DB2数据库

SELECT *

FROM (SELECT * ROW_NUMBER() OVER({ORDER BY COL1 DESC}) AS ROWNUM FROM TABLENAME)

WHERE ROWNUM <= N

或者

SELECT COLUMN FROM TABLENAME FETCH FIRST N ROWS ONLY

4. SQL Server数据库

SELECT TOP N * FROM TABLENAME

5. Sybase数据库

SET ROWCOUNT N

GO

SELECT * FROM TABLENAME

6. MySQL数据库

SELECT * FROM TABLENAME LIMIT N

2 DB2

select column from [tableName] where [query condition] fetch first 10 rows only

3 MySQL

select * from [tableName] where [query condition] limit 10

4 SQL Server

4.1 读取前10条

select top (10) * from [tableName] where [query condition]

4.2 读取后10条

select top (10) * from [tableName] order by id desc

4.3 按照某个排序，第5到10这几个记录

select top 6 * from [tableName] where id not in(select top 4 id from [tableName])

5 Oracle

select * from [tableName] where rownum<=10

Oracle查询第10行到第100行的数据

select * from (select t.*,rownum as rn from table_name t) where rn between 10 and 100;

1、Oracle查找表中字段的值是否为空？

select * from table_name where 字段名 is (not) null;

2、查找表中字段是否是某个值

select * from table_name where 字段名='字段值';

3、更改表中字段原来的值为新的值

update table_name SET 字段名=‘新的字段值’ where 字段名=‘旧的字段值’