Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
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
what is a constraint? Tell me about its various levels. : Sql dba
Is sql dba a good career? : SQL DBA
Why do we use subquery?
What is primary key and unique key?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What port does sql server use?
Define implicit and explicit cursors.
What do you mean by stored procedures? How do we use it?
What view means?
What is bind reference and how can it be created?
What is the life of an sql statement?
What is numeric function sql?
Define commit, rollback and savepoint?
What is the purpose of design view?
How would you convert date into julian date format?