Syntax: SELECT TOP number|percent column_name(s) FROM table_name WHERE condition; Example: SELECT TOP 3 * FROM Customers;
SELECT TOP 1000 * FROM Customer;
SELECT ROWNUM, a.* FROM (SELECT customers.* FROM customers WHERE customer_id > 4500 ORDER BY last_name) a;