Select first 10 records of a file

harrisjah · #1 (**permalink**) 01-22-04, 05:14

How do you compose an SQL statement so that only the first say 10 records are returned to your generic Select statement.

marp · #2 (**permalink**) 01-22-04, 05:16

SELECT TOP 10 * FROM ...

Quote:

Originally posted by harrisjah
How do you compose an SQL statement so that only the first say 10 records are returned to your generic Select statement.

r123456 · #3 (**permalink**) 01-22-04, 07:04

Oracle,

Select *
from table
where rownum <=10;

Internet Services

Web Development

Digital Marketing

Consumer Tech