Postgres Pro
Downloads
Home   >   mailing lists

Rank - Mailing list pgsql-sql

From Muhyiddin A.M Hayat
Subject Rank
Date
Msg-id 002001c42f80$aa192330$4f00a8c0@MIDDINKS
Whole thread Raw
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: "Alain Reymond"
Date:
Subject: Database structure
Next
From: "Sebastian Tewes"
Date:
Subject: invalid input syntax for integer: ""