MySQL Forums
Forum List  »  General

How to select the sequence no from table
Posted by: venu jayaramaiah
Date: August 21, 2009 04:50AM

Hi,

I i am facing one problem. from the following table i want to select
currentseqNo -nextSeqNo =1, in the below code i have to 10 to 14.

please tell me the how to write the query. not using procedure

table structure

seqNo
_______

10
11
12
13
14
20
21
22
23

Options: ReplyQuote


Subject
Written By
Posted
How to select the sequence no from table
August 21, 2009 04:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.