OraFAQ Forum: SQL & PL/SQL » query to find top three salaries of each department in emp table

Home » SQL & PL/SQL » SQL & PL/SQL » query to find top three salaries of each department in emp table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

query to find top three salaries of each department in emp table [message #10037]

Thu, 25 December 2003 22:21

atul
Messages: 17
Registered: September 1999

Junior Member

query to find top three salaries of each department in emp table

Report message to a moderator

Re: query to find top three salaries of each department in emp table [message #10038 is a reply to message #10037]

Thu, 25 December 2003 22:53

Vishal
Messages: 1
Registered: December 2003

Junior Member

SELECT * FROM (
SELECT deptno, ename, sal,
DENSE_RANK()
OVER (
PARTITION BY deptno ORDER BY sal desc
) TopN FROM emp
)
WHERE TopN <= 3
ORDER BY deptno, sal DESC
/

Report message to a moderator

Previous Topic:	Compile error in PL/SQL Interpreter
Next Topic:	Query contains multipule records but need to fetch the first row

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 10:26:55 CDT 2024