How to select first 5 records from a table?
Solution
-- Oracle Soltuion
SELECT * FROM HR.employees WHERE ROWNUM <= 5;
-- Generic Solution
SELECT * FROM HR.employees emp
WHERE (SELECT count(*) FROM HR.employees i
WHERE i.employee_id < emp.employee_id) < 5