Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 44640 Views
- Cap Gemini, iNautix, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is difference between table and view?
What is data control language (dcl)?
How can I tell if sql is running?
What is error ora-12154: tns:could not resolve the connect identifier specified?
What is the difference between inner join and left join?
How many types of relationship are there?
Can we use having without group by in sql?
what is union? : Sql dba
How do you write a complex sql query?
How to select random rows from a table?
Show the two pl/sql cursor exceptions.
What are hotfixes and patches?
How to create a menu in sqlplus or pl/sql?
How can check sql version from command line?
Can we call a function containing dml statements in a select query?
