Row Number

[KLLW]

I have a table that will be sorted descending by a number field. I want to apply another column that will contain sequential number starting with 1. Something like this:


DATA_COL _number
25 1
20 2

10 3

2 4

1 5


I have tried DCOUNT but am having a hard time with syntax.

 

[plog]

What is your syntax?

 

[KLLW]

I got it to work.

 

[Yev18]

If your table is Table1 with the column to be sorted DATA_COL _number, then if you join it to itself

You can have a query

Select Table1.DATA_COL _number, count(*) as rank
from Table1, Table1 as T1
where
T1.DATA_COL _number>=Table1.DATA_COL _number
Group by Table1.DATA_COL _number
order by Table1.DATA_COL _number DESC

This gives the result you want.

 

[Gasman]

It would be polite to post what worked for you, as it could help someone else in the future.?

I got it to work.