Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
Answer Posted / ajay dond
select salary from (select distinct salary from employees
order by salary desc)
where rownum<6
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to drop an existing view in mysql? : Sql dba
What is cursor and why it is required?
Why do we create views in sql?
How do I start sql from command line?
How do you remove duplicate records from a table?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is a sql statement?
Is sqlexception checked or unchecked?
What is the difference between union and union all command?
Is join same as left join?
What is right join in sql?
What is the trigger in sql?
how many groups of data types? : Sql dba
What is pl sql architecture?
Why are sql stored procedures used?