Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How would you retrieve the first five records
I am new to sql, I want to retrieve the first five records that satisfy a condition and get the last record number checked by sql.
Let's say I have 10000 records, some 5000 records includes the string "dollar", but I need to retrive only the first five records that include this string, and I want to get the record number of the first record that comes immediatly after the fifth retrieved record.
I check the syntax of "select" but it does not have a way to get my results, any help would be very much appreciated.
Thanks everybody.
Susan
Toronto, Canada
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Mar 28 1999 - 14:54:00 CST