-- For SQL Server
SELECT TOP 10 * FROM Customers;
-- For MySQL and PostgreSQL
SELECT * FROM Customers LIMIT 10;
-- For Oracle
SELECT * FROM (SELECT * FROM Customers) WHERE ROWNUM <= 10;
code
code
-- For SQL Server
SELECT TOP 10 * FROM Customers;
-- For MySQL and PostgreSQL
SELECT * FROM Customers LIMIT 10;
-- For Oracle
SELECT * FROM (SELECT * FROM Customers) WHERE ROWNUM <= 10;