Order by

[artur]

Good morning,

I have a table ID (primary key) and

ID
--
FEASSDDE
RDSAAASE
NEESSDSD
AEIERIEIEE

and I want to do a select of these values, order by ID ASC, and see the position of each one in this order, something like this:

POS        ID
--------------------
1           AEIERIEIEE
2           FEASSDDE
3           NEESSDSD
4           RDSAAASE

 

[wazz]

where do you want to see the position? form? report? table?

 

[artur]

Thanks for your reply,

On my TABLE I have the information like this:

ID
--
FEASSDDE
RDSAAASE
NEESSDSD
AEIERIEIEE

And what I need is to create a QUERY where I do ORDER BY ID, and to know the position of each ID in this order, something like this:

POS ID
--------------------
1 AEIERIEIEE
2 FEASSDDE
3 NEESSDSD
4 RDSAAASE

POS is nowhere, just auto-increment. Do you get the idea? THANKS!