正文

MYSQL:

select * from tbl limit 10; 

ORACLE:

select * from tbl where rownum<=10; 

SQL SERVER:

select top 10 * from tbl;

SYBASE:

SET ROWCOUNT 10 GOSELECT * FROM TABLE1;

达梦数据库：limit、top等都可以实现。