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?