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