select sal from (select rownum,sal from emp order by sal desc) where row

how to retrieve the top 3 salaries of the table using rownum

Question Posted / akki julak

Answer Posted / akki julak

select sal from (select rownum,sal from emp order by sal
desc)
where rownum<4;

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the operators used in select statements?

998

What are actual parameters and formal parameters?

1033

Is natural join and inner join same?

853

What does closing a cursor do?

1240

Can triggers stop a dml statement from executing on a table?

1023

what is sp_pkeys? : Transact sql

1098

How does an execution block start and end in pl sql?

899

What is before trigger?

943

Define SQL and state the differences between SQL and other conventional programming Languages?

1138

What does where 1/2 mean in sql?

1006

How do I find duplicates in the same column?

996

What is a recursive stored procedure?

1094

Which are the different case manipulation functions in sql?

952

How to display Row Number with Records in Oracle SQL Plus?

990

How do I run a sql query in pgadmin 4?

904