How to select first 5 records from a table?

Technology CommunityCategory: SQLHow to select first 5 records from a table?
VietMX Staff asked 3 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