Archive
SQL Server의 SELECT TOP과 동일한 쿼리들 (MySQL, Oracle, DB2)
epicdev
2013. 5. 26. 15:51
SQL Server
SELECT TOP n
FROM table_name
MySQL
SELECT *
FROM table_name
LIMIT n
Oracle
SELECT *
FROM table_name
WHERE ROWNUM <= number
DB2
SELECT *
from table_name
FETCH FIRST n ROWS ONLY