SQL SELECT TOP

SQL Server / MS Access Синтаксис:

SELECT TOP number|процент column_name(s)
FROM table_name
WHERE condition

MySQL Синтаксис:

SELECT column_name(s)
FROM table_name
WHERE condition
LIMIT number

Oracle 12 Синтаксис:

SELECT column_name(s)
FROM table_name
ORDER BY column_name(s)
FETCH FIRST number ROWS ONLY

Устаревший Oracle Синтаксис:

SELECT column_name(s)
FROM table_name
WHERE ROWNUM <= number

Устаревший Oracle Синтаксис (with ORDER BY):

SELECT *
FROM (SELECT column_name(s) FROM table_name ORDER BY column_name(s))
WHERE ROWNUM <= number