MySQL Forums
Forum List  »  Newbie

retrieving order number
Posted by: Alex Nedelcu
Date: February 02, 2005 04:29AM

is there a way to retrieve the order number along with the other fields in a select statement ?

for example if I have a query that selects the following results:

ID Value
-----------
1 1345
3 8275
5 2384
7 2345

I want a way to retrieve the following results:

Recno ID Value
--------------------
1 1 1345
2 3 8275
3 5 2384
4 7 2345

Options: ReplyQuote


Subject
Written By
Posted
retrieving order number
February 02, 2005 04:29AM


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.