top in sql

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;

1
2 SELECT TOP 3 * FROM Customers;
3 

1In MySQL, top 50 rows are displayed by using this following query:
2SELECT * FROM
3LIMIT 0, 50;