In this article we wre going to learn , how to select N number of records from table in MySQL and Oracle

MySQL Syntax :
SELECT column1 , column2 , column3 ….
FROM table_name
LIMIT number;
Example :
SELECT * FROM Employee LIMIT 7;
Oracle Syntax:
SELECT column1 , column2 , column3 ….
FROM table_name
WHERE ROWNUM <= number;
Example :
SELECT * FROM Employee WHERE ROWNUM <=7;