select empname,sal from (select empname,sal from dh1 order by sal desc)

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

Question Posted / dhiman sarkar

Answer Posted / dhiman sarkar

select empname,sal from (select empname,sal from dh1 order
by sal desc)
where rownum < =4
order by sal desc

Is This Answer Correct ?

17 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Is postgresql a server?

997

What is oracle and pl sql?

1081

How do I partition a table in sql?

1045

What is the difference between sql and isql*plus?

1007

Is left join faster than inner join?

1065

Can function return multiple values in sql?

988

How do you delete a table?

1001

How to revise and re-run the last sql command?

1101

What are the different types of triggers?

1056

Is coalesce faster than isnull?

909

How to know the last executed procedure?

1035

What is minus?

940

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

993

Why is pl sql used?

939

What is sql deadlock?

1050