Write a query to find five highest salaries from EMP table.
(there is a column SALARY)

Answers were Sorted based on User's Feedback



Write a query to find five highest salaries from EMP table. (there is a column SALARY)..

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

Write a query to find five highest salaries from EMP table. (there is a column SALARY)..

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

Write a query to find five highest salaries from EMP table. (there is a column SALARY)..

Answer / sankarapandian

select top 5 salary from employee
order by salary desc

Is This Answer Correct ?    17 Yes 8 No

Write a query to find five highest salaries from EMP table. (there is a column SALARY)..

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

Write a query to find five highest salaries from EMP table. (there is a column SALARY)..

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

Write a query to find five highest salaries from EMP table. (there is a column SALARY)..

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

Write a query to find five highest salaries from EMP table. (there is a column SALARY)..

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

Write a query to find five highest salaries from EMP table. (there is a column SALARY)..

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

Write a query to find five highest salaries from EMP table. (there is a column SALARY)..

Answer / seetharam

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

Is This Answer Correct ?    3 Yes 3 No

Write a query to find five highest salaries from EMP table. (there is a column SALARY)..

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

Post New Answer

More SQL PLSQL Interview Questions

How do I view a sql database?

0 Answers  


what is uncommittable transactions? : Transact sql

0 Answers  


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.....

8 Answers  


Can cursors be part of a trigger body?

0 Answers  


Is sql better than access?

0 Answers  






Explain the two type of Cursors ?

8 Answers   Hi Caliber IT,


What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,


What is difference between sql and oracle?

0 Answers  


What are the different datatypes available in PL/SQL?

0 Answers  


How do sql triggers work?

0 Answers  


How delete all data from table in sql?

0 Answers  


Name three sql operations that perform a sort.

0 Answers  


Categories