[SQL] Rank

[Muhyiddin A.M Hayat]

Dear All,   I Have below table    id | site_name | point ----+-----------+-------   1 | Site A    |    40   2 | Site B    |    90   3 | Site D    |    22   4 | Site X    |    98    Would like to calc that Rank for each site, and look like        id | site_name | point | rank ----+-----------+-------+------   1 | Site A    |    40 |    3   2 | Site B    |    90 |    2   3 | Site D    |    22 |    4   4 | Site X    |    98 |    1   What can I do to get result like that