-
1. Re: Selecting fewer records from thousands
manimbul Jun 28, 2002 8:28 AM (in response to mkent)>> Is there a way to select only a few records by
>> specifying a number of records to return and a
>> starting value?
yes there is,
it's best to use database feature
and oracle give that feature
example:
we want to select record from table Employee from line 30 to 40 where in this table available 10000 records.
the SQL statement look like this
(SELECT * FROM Employee WHERE ROWNUM < 40) minus
(SELECT * FROM Employee WHERE ROWNUM < 30)
the result of this SQL statement is 10 records that beginning from line 30 and finish to line 40
(sorry if syntax not correct, just refer to oracle documentation about the syntax :-) )
hope this help..
Note:
not all database give that feature, another database I know have this feature is PostgreSQL with syntax LIMIT and OFFSET.
regards,
Manimbul Simorangkir