select sal from (select distinct sal from emp order by sal desc ) where r

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

Question Posted / seema

Answer Posted / seema

select sal from (select distinct sal from emp order by sal
desc ) where rownum < 3;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is materialized view. What are different methods of refresh?

1330

What does the acronym acid stand for in database management?

983

Is primary key is clustered index?

938

What is the difference between nested table and varray?

942

What does dml mean?

928

What is meaning of <> in sql?

1020

What is prepared statement in sql?

993

What are the different types of dbmss?

963

What are the various levels of constraints?

1059

Is pl sql better than sql?

979

Why do we need a foreign key?

1021

What is view? Can we update view

1352

What is sqlerrm?

882

Where is sql database stored?

919

What information is needed to connect sql*plus an oracle server?

978