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

Differentiate pl/sql and sql?

1052

Can we call a function containing dml statements in a select query?

960

what is a database lock ? : Sql dba

1151

how to return query output in html format? : Sql dba

1059

Where not exists in sql?

965

How bulk collect improves performance?

984

How many types of triggers are there in pl sql?

1050

Can you call pl/sql package functions from within a fast formula?

1021

How does sql profiler work?

1001

What steps server process has to take to execute an update statement?

963

What is integrity in sql?

1022

Which data dictionary views have the information on the triggers that are available in the database?

1225

what are the types of subquery? : Sql dba

1088

Sql technical questions

1253

What is a sql profiler?

1002