|
View previous topic :: View next topic
|
| Author |
Message |
rsm_deepak
New User
Joined: 06 Apr 2005
Posts: 30
Location: visakhapatnam
|
|
|
|
Hi,
I want to know is there any query for fetching the next record without using a CURSOR. |
|
| Back to top |
|
 |
birdy K
New User
Joined: 05 Mar 2008
Posts: 72
Location: chennai
|
|
|
|
Hi,
You can use fetch first row only in the select statement. But you have given as next record. Give the condition in where clause as per your requirement and fecth the next record. For ex If you know the current value then you can given as ">" current value and fetch first row alone. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| I want to know is there any query for fetching the next record without using a CURSOR. |
If you do not declare a cursor and open it to "select the set" of matching data, there is no "next record". . . |
|
| Back to top |
|
|
|
|
