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
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
What is the difference between the content store and content manager?
Where do you set security levels for users in reports?
Give the advantages of cognos?
What are slice and dice?
in which scenario we go for views in cognos or oracle?
Explain about embedded & standalone filters?difference between them
How can you link a query to a data container manually in Report Studio?
What is the difference between regular dimension and derminant?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
what are the uses of report studio,q.studio,analysis studio,event studio&.metric studi.
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?