Posted by evandroc on 04/04/06 03:11

Hello all,


I´m currently using a SQL Serve 2K. Would like to do a select
which returns the row number - this should not be physically stored in
the database. So for example, I would like to do a query against the
CUSTOMER table and receive:

* rowID || name
1 Evander
2 Ron
3 Scoth
4 Jane

I don´t want to store the ID, because if I change the order by
clause, the sequence may modifiy, and, for another example, having the
same set of data, I would receive:

* rowID || name
1 Scoth
2 Ron
3 Jane
4 Evander

could someone help me ?

best regards,
Evandro

• Next in forum: Re: Full text indexing with Japanese characters problem
• Prev in forum: Row sequence number
• Thread view: Row sequence number

[Reply to this message]