select top 10 ..ORACLE, MSSQL

TOP 10개만 가져오는 쿼리문

[ORACLE]

SELECT *
  FROM [TABLE]
  WHERE ROWNUM <= 10


[MSSQL]

 SELECT TOP 10 *
  FROM [TABLE]

[MYSQL]

 SELECT *
  FROM [TABLE]
LIMIT 0, 3