The SQL SELECT TOP Clause
- SQL Server / MS Access Syntax:
- SELECT TOP number|percent column_name(s) FROM table_name.
- MySQL Syntax: SELECT column_name(s) FROM table_name.
- Oracle 12 Syntax: SELECT column_name(s) FROM table_name.
- Older Oracle Syntax: SELECT column_name(s)
- Older Oracle Syntax (with ORDER BY): SELECT *
Shathana. S.R. Answered question May 29, 2023