| From: | "Muhyiddin A(dot)M Hayat" <middink(at)indo(dot)net(dot)id> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Rank |
| Date: | 2004-05-01 13:30:53 |
| Message-ID: | 002001c42f80$aa192330$4f00a8c0@MIDDINKS |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Eckermann | 2004-05-01 14:29:16 | Re: isnumeric() function? |
| Previous Message | Tom Lane | 2004-05-01 04:37:48 | Re: Performance issue |