View previous topic :: View next topic
|
Author |
Message |
pankajji Currently Banned New User
Joined: 03 Jan 2007 Posts: 5 Location: Delhi
|
|
|
|
Hi,
suppose there are 100 records in a table, I want to select 10records starting from 11th to 20th. What query should I use?
Thanks |
|
Back to top |
|
|
jamshirqureshi
New User
Joined: 13 Aug 2006 Posts: 20 Location: mumbai
|
|
|
|
hi,
fetch the cursor with the range,
like
fetch into key 11 to 20
host variable.
thx
jamz |
|
Back to top |
|
|
pankajji Currently Banned New User
Joined: 03 Jan 2007 Posts: 5 Location: Delhi
|
|
|
|
jamshirqureshi wrote: |
hi,
fetch the cursor with the range,
like
fetch into key 11 to 20
host variable.
thx
jamz |
Hi,
How can I see the same 10 row by QMF. |
|
Back to top |
|
|
|