Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 47566 Views
- Cap Gemini, iNautix, I also Faced
- E-Mail Answers
Answer Posted / amit bharane
select salary from employees
where rownum<=5
order by salary desc
| Is This Answer Correct ? | 3 Yes | 22 No |
Post New Answer View All Answers
Which is faster joins or subqueries?
Does truncate table reset auto increment?
Can pl sql procedure have a return statement?
Does sql profiler affect performance?
what is transaction? : Sql dba
What are sql queries used for?
How do I add a database to sql?
how to load data files into tables with 'mysqlimport'? : Sql dba
What is composite primary key in sql?
What are the differences between in and exists clause?
Can a view be mutating? If yes, then how?
What are the different types of dbms?
How do you determine the current isolation level? : Transact sql
How do you write an index?
Is t sql a programming language?
