select a.* from(select empno,ename,sal from emp order by sal

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

Question Posted / kavitha nedigunta

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

Please Help Members By Posting Answers For Below Questions

What is pl sql block in dbms?

952

how many columns can be used for creating index? : Sql dba

899

Can we call procedure in select statement?

976

Can we use ddl statements in stored procedure sql server?

966

How do you rank data in sql?

938

what are the advantages of using stored procedures? : Sql dba

1061

What is cte sql?

930

What does pl sql stand for?

1065

What is normalization? How many normalization forms are there?

1013

What is the starting oracle error number? What is meant by forward declaration in functions?

940

Which certification is best for sql?

940

what is the difference between join and union? : Sql dba

1030

what is primary key? : Sql dba

956

What does t sql mean?

898

Which one is faster ienumerable or iqueryable?

866