Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
Answers were Sorted based on User's Feedback
Answer / yogesh sharma
SELECT ENAME,SALARY FROM (SELECT ENAME,SAL FROM EMP ORDER BY SALARY DESC ) WHERE ROWNUM<6;
Is This Answer Correct ? | 77 Yes | 13 No |
Answer / priya
SELECT Rownum,emp-name,salary
FROM(SELECT emp_name,salary
FROM employees
ORDER BY salary Desc)
WHERE Rownum<=5;
Is This Answer Correct ? | 17 Yes | 3 No |
Answer / sankarapandian
select top 5 salary from employee
order by salary desc
Is This Answer Correct ? | 17 Yes | 8 No |
Answer / sarath
select ename,sal,SAlrank from(select ename,sal,dense_rank()
over(order by sal desc) Salrank from emp)
where salrank <=5
Is This Answer Correct ? | 9 Yes | 2 No |
Answer / nitin umale
SELECT last_name, salary
FROM (select last_name, NVL(salary,0) salary
FROM employees
ORDER BY NVL(salary,0) DESC )
WHERE rownum<6;
Is This Answer Correct ? | 9 Yes | 3 No |
Answer / sreenivasreddy
SELECT ROWNUM, E1.*
FROM (SELECT EName, Deptno, Sal,
DENSE_RANK()
OVER(ORDER BY Sal DESC) EmpRank
FROM Emp
GROUP BY Deptno, EName, Sal
ORDER BY EmpRank) E1
WHERE E1.EmpRank <= 5
ORDER BY ROWNUM
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / vishnu
select level,max(sal) from emp
where level<=5
group by level
connect by prior sal>sal
order by level Asc;
Is This Answer Correct ? | 5 Yes | 3 No |
Answer / mk
SELECT ENAME,SALARY FROM (SELECT ENAME,SAL FROM EMP ORDER
BY SALARY DESC ) WHERE ROWNUM<6;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / seetharam
select * from(select * from emp order by sal desc) where
rownum<=5;
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / amit bharane
select empid,salary
from (select empid,salary
from emp
order by sal desc)
where rownum <=5;
Is This Answer Correct ? | 0 Yes | 0 No |
What are aggregate and scalar functions?
What has stored procedures in sql?
Can we have two clustered index on a table?
What port does sql server use?
What are keys in sql?
What is difference between sql and oracle?
what is the difference between char_length and length? : Sql dba
What are system versioned tables?
What is the difference between sum and count in sql?
How many developers work on postgresql?
what is the difference between primary key and unique key? : Sql dba
how will i became good database developer?