sql select top
-- SQL Server / MS Access Syntax: SELECT TOP number|percent column_name(s) FROM table_name WHERE condition; -- MySQL Syntax: SELECT column_name(s) FROM table_name WHERE condition LIMIT number; -- Oracle 12 Syntax: SELECT column_name(s) FROM table_name ORDER BY column_name(s) FETCH FIRST number ROWS ONLY; -- Older Oracle Syntax: SELECT column_name(s) FROM table_name WHERE ROWNUM <= number;