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 / k.prashanth
Select
ename,sal,deptno
from emp
where sal in
(select max
(sal) from emp
where
level<=5
connect by
prior sal<sal
group by level)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / manoranjan sethy
Method 01:
---------
Select Ename, MAX (Sal) From Emp
Group by ROWNUM, Ename
Having Rownum <=5;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vivek dubey
this Query is wrong : " SELECT ENAME,SALARY FROM (SELECT ENAME,SAL FROM EMP ORDER BY SALARY DESC ) WHERE ROWNUM<6; " because We can not use Order by clause in SubQuery.
This Answer gives you the right data :
"
SELECT TOP 5
empsal.ENAME,
empsal.SAL
FROM
(
SELECT ENAME,SAL
FROM EMP
) AS empsal
ORDER BY empsal.SAL DESC
"
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ajay dond
select salary from (select distinct salary from employees
order by salary desc)
where rownum<6
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ram
select ename,salary from(select ename,salary from emp order by salary desc) where rownumber<6
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kishore
select salery from (select salery from
emp order by salery desc) where rownum <=5 ;
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / manjunath u
select salary from(select salary from emp order by salary
desc)where rownum<=5;
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / kavitha nedigunta
select a.*
from(select empno,ename,sal
from emp
order by sal desc nulls last)a
where rownum <6
order by sal desc
Is This Answer Correct ? | 3 Yes | 5 No |
Answer / mohammad murtuza ali
select * from emp as(empname,empsal,empdesc) where rownum<6
Is This Answer Correct ? | 1 Yes | 4 No |
Why are aggregate functions called so?
What are the different types of joins and explain them briefly.
What is serial sql?
What is before and after trigger?
What is execute immediate?
Can a foreign key be a duplicate?
What is a natural join sql?
What is basic structure of pl sql?
which will fire first ? Trigger or Constraint
24 Answers i2, IBM,
How to start the command-line sql*plus?
what are the difference between clustered and a non-clustered index? : Sql dba
what are all the common sql function? : Sql dba