Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 52282 Views
- Cap Gemini, iNautix, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is prepared statement in sql?
how to calculate expressions with sql statements? : Sql dba
What is mdf ldf and ndf?
What are different types of indexes?
How can you view the errors encountered in a trigger?
What is primary key secondary key alternate key candidate key?
What is a full join?
how many values can the set function of mysql take? : Sql dba
Is the primary key an index?
Can we call stored procedure in function?
Is sql workbench free?
What is the default isolation level in sql server? : Transact sql
what is sub-query? : Transact sql
What is percent sign in sql?
What is trigger in sql and its types?
