select sal from (select sal from emp order by val desc) where rownum <

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

Question Posted / debanjan rudra

Answer Posted / debanjan rudra

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

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the use of non clustered index?

930

What is sql and also describe types of sql statements?

998

What is pls integer?

985

Which command is used to delete a package?

1092

How do you explain an index number?

1023

What is sqlcommand?

965

Why stored procedure is faster than query?

951

Is sql workbench free?

932

How do I create a sql script?

1052

Can primary key be changed?

871

What are the two characteristics of a primary key?

927

How sql query is executed?

1069

What is Materialized View? In What Scenario we Use Materialized View?

9401

Why is stored procedure faster than query?

909

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

933