Oralce/MySql/SqlServer/Informix 查询前几行

SqlServer

 select top 10 * from tablename;

Informix

select first 10 * from tablename;

Oralce

select * from tablename where rownum<=10;

MySql

select * from tableName limit 10

 开发者博客：www.developsearch.com