Record set part by part 
Author Message
 Record set part by part
Hi all,

How can I retrieve a record set segment by segment.

ex:- If I say "select * from some_table" and it returns 100 rows,

How can I only retrieve the rows from 20 to 30. I do not want to go from the
first row to the 20th one. Is it possible and what is the SQL syntax for

Thanks in advance.....
kind regards


Sun, 23 Dec 2001 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. Record Set part by part

2. Profile of of a DBA - part System Admn / Part Network Admin / Part Web Admin

3. Master Parts/Sub Parts/Sub-Sub Parts

4. precision parts, bicycle parts, optical parts, electronic components

5. Creating a record set based on part of another recordset using an SQL Statement

6. adding the date part of datetime to the time part of datetime

7. part numbers and part descriptions

8. Parts is Parts

9. Indexing One Part of a Multi-Part Item ID

10. ADO: part of Windows or part of Office?

11. Retrieving Row Index as part of Result set??

12. How to select part of query result set.

Powered by phpBB® Forum Software