Oralce/MySql/SqlServer/Informixクエリーの最初の行
428 ワード
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