Hi!

I have a request of having a select statement displaying a list of values in descending order and another column that tells what record it is.

something like this:

id | value | no
4 345 1
7 234 2
2 143 3
9 32 4
3 4 5

...

is this possible?

can it be something like this:

select id, value, increment(1,1) as no from tblTable
order by value desc

thanks.