how to find the 5th highest salary form each department using 1.SQL Qu

how to find the 5th highest salary form each department
using 1.SQL Query
2. Informatica power center designer?

Question Posted / janibasha.job

4 Answers
24372 Views
CTC, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to find the 5th highest salary form each department using 1.SQL Query ..

Answer / kondeti srinivas

sql query:
SELECT * FROM (SELECT DEPTNO,SAL,RANK()OVER (PARTITION BY DEPTNO ORDER BY SAL DESC) AS RNK) WHERE RNK=5

IN INFORMATICA

SOURCE ---SQ--RANK TANSFORMATION IN THAT SELECT DEPTNO AS GROUP BY PORT AND SAL AS RANK PORT AND SELECT TOP AND RANK =5

OUT PUT FROM RANK WILL BE DEPARTMENT WISE TOP 5 SALARIES ARE DISPLOYED AND FROM RANK TRANFORMATION CONNECT ALL PORTS INCLUDE RANKINDEX TO FILTER GIVE A CONDITION LIKE RANKINDEX=6

AND CONNECT ALL PORTS TO TARGET

Is This Answer Correct ?

14 Yes

6 No

how to find the 5th highest salary form each department using 1.SQL Query ..

Answer / yaseen

Select deptno,distinctsal from emp A where 5= (select count(distinctsal) from emp B where A.sal <= B.sal) groupby deptno

SQ----Rank TR-----Target
Rank t/R ---Group by on Deptno, Top --5

Plz correct if I am wrong

Is This Answer Correct ?

2 Yes

0 No

how to find the 5th highest salary form each department using 1.SQL Query ..

Answer / kumar

Can be implemented using RANK Analytic function

http://netezzamigration.blogspot.com/2014/10/analytic-functions-in-netezza.html

Is This Answer Correct ?

0 Yes

0 No

how to find the 5th highest salary form each department using 1.SQL Query ..

Answer / saleem

SQL query:
select rownum,empno,ename,job,sal from (select
rownum,empno,ename,job,sal from emp rder by sal desc)
group by rownum,empno,ename,job,sal having rownum =&n;
(with this query we will get which highest salary u want)

Is This Answer Correct ?

3 Yes

9 No

Post New Answer