Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?

Answers were Sorted based on User's Feedback



Write a SQL query which should fetch the 5th maximum salary of an employee from the table?..

Answer / vsandhyana

Hi Hashmatulla Baig,

I think your query will not give the desired output. it
should be modify please refer below for the same.

SELECT empno, sal
FROM
(
select empno, sal, (ROW_number() OVER (order by sal desc)) R
from emp
order by sal desc
)
WHERE R = 5;

Is This Answer Correct ?    4 Yes 1 No

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?..

Answer / balanandam

select * from emp where sal =(select sal from(select sal,rank() over(order by sal desc) sal_rank from emp group by sal) where sal_rank=&rank)

Is This Answer Correct ?    2 Yes 0 No

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?..

Answer / dramesh511

select sal from emp e where 5=(select count(sal) from
emp e1 where e.sal<=e1.sal)

Is This Answer Correct ?    2 Yes 0 No

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?..

Answer / hashmatulla baig

SELECT empno, sal
FROM
(
select empno, sal, ROW_number() OVER (order by sal desc) R
from emp
order by sal desc
)
WHERE R = 5;

Is This Answer Correct ?    3 Yes 2 No

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?..

Answer / karthik murugeshan

SELECT B.Salary FROM (SELECT Salary FROM EMP)A,(SELECT
Salary FROM EMP)B
WHERE A.Salary>=B.Salary
GROUP BY B.Salary
HAVING COUNT(B.Salary)=5

Is This Answer Correct ?    3 Yes 3 No

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?..

Answer / balanandam

select * from((select * from emp order by sal desc where rownum<=5)MINUS(select * from emp order by sal desc where rownum<=4))

Is This Answer Correct ?    0 Yes 0 No

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?..

Answer / dhanu

SELECT DISTINCT SAL FROM EMP E WHERE 5>=(SELECT COUNT(DISTINCT SAL) FROM EMP A WHERE A.SAL<=E.SAL)ORDER BY SAL DESC

Is This Answer Correct ?    0 Yes 0 No

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?..

Answer / sreenivasa

SELECT DEPTNO, ENAME, SAL FROM EMP A WHERE 4 = (SELECT COUNT
(B.SAL) FROM EMP B WHERE A.SAL < B.SAL)

Is This Answer Correct ?    0 Yes 0 No

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?..

Answer / pradeep nagireddy

select *
from(select rownum r,sal from emp order by sal desc)
where rownum = 5;

Is This Answer Correct ?    0 Yes 0 No

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?..

Answer / srcreddy

select* from
(select rownum rank,ename,sal from emp order by sal desc) where rank=5;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

What is defined as Cognos Impromptu?

0 Answers  


1)How can we do the Union in Report Studio? 2)What is the meaning of Aggregation and Rollup Aggregation? 3)How can we hide the columns in Report Studio and How can we view the hiding Objects? 4)Can we provide joins in Report Studio and in which situation we can go for outer join? 5)If we take a Date Prompt and run it once it will show default data,how can we change it exact 1 month back data?

1 Answers  


What DB View and Bus View?

0 Answers  


How create measures and dimensions?

0 Answers  


What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?

5 Answers   IBM,


In a Single page we are having 3 list. While running each has to populated in separate page?

2 Answers   TCS,


What are different events in Report studio?

0 Answers   Wipro,


What you mean by drill across?

0 Answers  


hi Here ive question on Reportnet when we save a report in reportstudio with what ext it save

6 Answers   iGate,


What is Regular Dimension and Measure Dimensions and Diff b/w them ?

2 Answers  


What is Clipboard? How to import XML file into Clipboard?

2 Answers   CSC, HCL,


What are all the types of hierarchies?

0 Answers  


Categories