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 |
How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?
28 Answers Alps, Aricent, Bank Of America, Wipro,
What is pl sql block structure?
What are the differences between implicit and explicit cursors?
what is a field in a database ? : Sql dba
What is scalar and vector?
When is a declare statement required?
What is the best partition size for windows 10?
Does pl sql work in mysql?
What are the types of join in sql?
Why do we need cursor in pl sql?
what is meant by tuning and tk proof?
What are stored procedures used for?