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 query optimization in sql?

723

What is database white box testing and black box testing?

853

How many columns should be in an index?

709

How to call a javascript function from pl sql?

760

What is autocommit sql?

708

How can I tell if sql is running?

761

Can we use threading in pl/sql?

712

what is the difference between char_length and length? : Sql dba

788

What is exception? What are the types of exceptions?

791

How many commands are there in sql?

748

Explain exception handling in pl/sql?

727

What is sql select statement?

703

How many sql core licenses do I need?

682

Explain the select statement in sql?

825

What is before and after trigger?

691