Sql - Rankproblem

[Helge's]

I have made this sql that works:

SELECT h1.Dato, h1.oms, (SELECT COUNT(*)
FROM tblOms AS h2
WHERE h2.oms <= h1.oms) AS Rank
FROM tblOms AS h1
ORDER BY oms;

The problem is that the lowest value get number 1. I want the higest
value to be number 1.

Is it an easy way to solve this?

[RoyVidar]

"Helge's" <he*************@chello.nowrote in message
<11**********************@i3g2000cwc.googlegroups. com>:

I have made this sql that works:

SELECT h1.Dato, h1.oms, (SELECT COUNT(*)
FROM tblOms AS h2
WHERE h2.oms <= h1.oms) AS Rank
FROM tblOms AS h1
ORDER BY oms;

The problem is that the lowest value get number 1. I want the higest
value to be number 1.

Is it an easy way to solve this?

Hei Helge!

Did you try swapping for <?

....WHERE h2.oms >= h1.oms) AS Rank

--
Roy-Vidar

[Peter Doering]

Helge's wrote:

I have made this sql that works:

SELECT h1.Dato, h1.oms, (SELECT COUNT(*)
FROM tblOms AS h2
WHERE h2.oms <= h1.oms) AS Rank
FROM tblOms AS h1
ORDER BY oms;

The problem is that the lowest value get number 1. I want the higest
value to be number 1.

ORDER BY oms DESC;

Peter

--
No mails please.