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
Can a commit statement be executed as part of a trigger?
How do I view a sql database?
what is the bond code in materialized view?
What are the operators used in select statements?
how can we optimize or increase the speed of a mysql select query? : Sql dba
Does sql use python?
What is composite primary key in sql?
What is an inner join sql?
What is partition by in sql?
What are different methods to trace the pl/sql code?
What are different sql data types?
What are the different parts of a package?
What is the difference between truncate and drop statements?
Can dml statements be used in pl/sql?
what is a primary key? : Sql dba