Sequence In Select Query

[paul29berks]

Does anyone know how I can set sequence numbers within a select query?

i.e a column called Sequence and then 1st row of my output = 1 then 2 etc

Thanks

Paul

 

[SydneyGeek]

SELECT * FROM SomeTable ORDER BY Sequence;

or,

SELECT * FROM SomeTable ORDER BY Sequence Desc;

To sort descending

Denis

 

[paul29berks]

Thanks for your reply.

this column needs to show the sequence i.e a count of each row. so row 1 = number 1 then 2 etc

How can I build this into the query?

Thanks

Paul

 

[SydneyGeek]

Hi Paul,

take a look at this link -- it should do what you need.

Denis

 

[Richard Schollar]

Denis

That's a really cool way to do that - thanks for the link!