1-- SQL Server / MS Access Syntax:
2SELECT TOP number|percent column_name(s) FROM table_name WHERE condition;
3-- MySQL Syntax:
4SELECT column_name(s) FROM table_name WHERE condition LIMIT number;
5-- Oracle 12 Syntax:
6SELECT column_name(s) FROM table_name ORDER BY column_name(s)
7 FETCH FIRST number ROWS ONLY;
8-- Older Oracle Syntax:
9SELECT column_name(s) FROM table_name WHERE ROWNUM <= number;
1syntax -> SELECT column_name(s)
2FROM table_name
3WHERE ROWNUM <= number
4////example///
5SELECT *
6FROM Persons
7WHERE ROWNUM <=5