Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 47508 Views
- Cap Gemini, iNautix, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is foreign key sql?
What is sql integrity?
Is null operator in sql?
What are the two characteristics of a primary key?
Explain about various levels of constraint.
How to fetch alternate records from a table?
How do I access sql anywhere database?
What is sql*loader?
What is sql profiling in oracle?
How to look at the current sql*plus system settings?
How do you explain an index number?
What is the use of prepared statement?
What is the benefit of foreign key?
Is big data nosql?
Why does sql need a server?
