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

 

Hi,

 

Jus wanted the equivalent for rank() as in tis example..

 

SELECT *
FROM (
  SELECT employee_id, last_name, salary,
  RANK() OVER (ORDER BY salary DESC) EMPRANK
  FROM employees)
WHERE emprank = 3;

 

Rgds,

Chandan

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