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

Does sql*plus have a pl/sql engine?

1077

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1151

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1057

Who is the owner of mysql database?

1059

How to move files from one directory to another in pl sql?

1196

Can there be more than one function with a similar name in a pl/sql block?

989

What are all the different types of indexes?

1152

What does the hierarchical profiler does?

1064

What is constant in pl sql?

1029

Explain how can you save or place your msg in a table?

1031

What are the types of records?

992

How many triggers can be applied on a table?

936

What is asqueryable?

980

How do I run a sql query in pgadmin 4?

966

How to process query result in pl/sql?

1136