select * from (select sal from emp order by sal desc) where rownum<=3

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

Question Posted / debbie

31 Answers
41874 Views
Oracle, I also Faced
E-Mail Answers

Answer Posted / debbie

select * from (select sal from emp order by sal desc)
where rownum<=3

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we call procedure in select statement?

1062

How do I view a view in sql?

956

is mysql query is case sensitive? : Sql dba

1107

What is the life of an sql statement?

1025

What is the difference between view and stored procedure?

962

Define join and name different types of joins?

1008

What are the types of triggers in sql?

1091

What is the difference between drop and truncate commands?

1063

Can we use view in stored procedure?

904

What is union?

1178

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2031

what is a database lock ? : Sql dba

1176

what is isam? : Sql dba

1016

What are conditional predicates?

1064

How do you determine the current isolation level? : Transact sql

1163