How to select first 5 records from a table? Technology Community › Category: SQL › How to select first 5 records from a table? 0 Vote Up Vote Down VietMX Staff asked 4 years ago -- SQL Server SELECT TOP 5 * FROM EMP; -- Oracle SELECT * FROM EMP WHERE ROWNUM <= 5; -- Generic SELECT name FROM EMPLOYEE o WHERE (SELECT count(*) FROM EMPLOYEE i WHERE i.name < o.name) < 5