データベース(oracle db2 mysql)にselect topの使い方

2016年8月20日

1.oracle
select * from tableName where rownum<=n

2.infomix
select first n * from tableName

3.db2
select * row_number() over(order by col1 desc) as rownum where rownum<=n

select column from table 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

7.foxpro
select * top n from table order by column