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 do I view a sql database?
what is uncommittable transactions? : Transact sql
i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....
Can cursors be part of a trigger body?
Is sql better than access?
Explain the two type of Cursors ?
What is difference between a PROCEDURE & FUNCTION ?
What is difference between sql and oracle?
What are the different datatypes available in PL/SQL?
How do sql triggers work?
How delete all data from table in sql?
Name three sql operations that perform a sort.