Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
Answer Posted / kavitha nedigunta
select a.*
from(select empno,ename,sal
from emp
order by sal desc nulls last)a
where rownum <6
order by sal desc
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
What is difference between db2 and sql?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
Why is a primary key important?
explain the advantages and disadvantages of stored procedure? : Sql dba
How do I get sql certification?
How can check sql version from command line?
How do I run sql profiler?
write an sql query to find names of employee start with 'a'? : Sql dba
Difference between table function and pipelined function?
How do I save the results of sql query in a file?
What is java sql driver?
Define SQL and state the differences between SQL and other conventional programming Languages?
When should I use nosql database?
How do I edit a trigger in sql developer?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql