Postgres Pro
Downloads
Home   >   mailing lists

Rank - Mailing list pgsql-sql

From Muhyiddin A.M Hayat
Subject Rank
Date
Msg-id 003e01c42fa9$5677b240$4f00a8c0@MIDDINKS
Whole thread Raw
Responses Re: Rank
Re: Rank
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: CoL
Date:
Subject: Re: isnumeric() function?
Next
From: "ashok@kalculate.com"
Date:
Subject: typecasting numeric(18,4) to varchar/text