select ename,salary from(select ename,salary from emp order by salary desc)

Write a query to find five highest salaries from EMP table.
(there is a column SALARY)

Question Posted / ram

Answer Posted / ram

select ename,salary from(select ename,salary from emp order by salary desc) where rownumber<6

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I create a memory optimized filegroup?

699

What is pivot table in sql?

740

What is the difference between alter trigger and drop trigger statements?

799

what is rollback? : Sql dba

758

What are the sql aggregate functions?

815

How do I run a sql query?

738

who introduced sql?

754

what is the use of set statement in tsql? : Transact sql

740

Can we use rowid as primary key?

738

how can you see all indexes defined for a table? : Sql dba

716

what is a tablespace? : Sql dba

766

What is the difference between partitioning and sharding?

730

what is self-join? : Sql dba

756

What is a table?

728

What are some emotional triggers?

751