Welcome Khaled,
You could put a counter initialized to 0 before the select and put an if statement within the loop that acts only when counter is between 10 and 15
e.g.
move 0 to #count
begin-select
col1
if #count >= 10 and #count <= 20
do processing
end-if
from table
end-select
Bob
-----Original Message-----
From: Khaled Abdel-Rahman [mailto:khaled.abdel-rahman@DB.COM]
Sent: Tuesday, October 26, 1999 12:22 PM
To: Multiple recipients of list SQR-USERS
Subject: Sybase - Selecting specific numbers of records
Hi,
This is my first question to the list an the following is my first
question!!!!!
Suppose you have a table which has 20 rows, I want to get only rows
from 10-15. How can I don that?!
Thanks in advance,
Best Regards,
Khaled