Postgres Pro
Downloads
Home   >   mailing lists

equivalent of oracle rank() in postgres - Mailing list pgsql-sql

From Chandan_Kumaraiah
Subject equivalent of oracle rank() in postgres
Date
Msg-id 2EB549AAAFEA264FA926269A5BD5E9EB14657F@certsrv.satyam.com
Whole thread Raw
Responses Re: equivalent of oracle rank() in postgres
List pgsql-sql
Tree view 
<div class="Section1"><p class="MsoNormal"><font face="Courier" size="3"><span style="font-size:12.0pt;
font-family:Courier"> </span></font><p class="MsoNormal"><font face="Courier" size="3"><span style="font-size:12.0pt;
font-family:Courier">Hi,</span></font><p class="MsoNormal"><font face="Courier" size="3"><span style="font-size:12.0pt;
font-family:Courier"> </span></font><p class="MsoNormal"><font face="Courier" size="3"><span style="font-size:12.0pt;
font-family:Courier">Jus wanted the equivalent for rank() as in tis example..</span></font><p class="MsoNormal"><font
face="Courier"size="3"><span style="font-size:12.0pt; 
font-family:Courier"> </span></font><p class="MsoNormal"><font face="Courier" size="3"><span style="font-size:12.0pt;
font-family:Courier">SELECT *<br /> FROM (<br />   SELECT employee_id, last_name, salary,<br />   RANK() OVER (ORDER BY
salaryDESC) EMPRANK<br />   FROM employees)<br /> WHERE emprank = 3;</span></font><p class="MsoNormal"><font
face="Courier"size="3"><span style="font-size:12.0pt; 
font-family:Courier"> </span></font><p class="MsoNormal"><font face="Courier" size="3"><span style="font-size:12.0pt;
font-family:Courier">Rgds,</span></font><p class="MsoNormal"><font face="Courier" size="3"><span
style="font-size:12.0pt;
font-family:Courier">Chandan</span></font><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial"></span></font></div>

pgsql-sql by date:

Previous
From: Jonathan Daugherty
Date:
Subject: Re: tablename as function parameter
Next
From: Richard Huxton
Date:
Subject: Re: Trigger with parameters