select top 3 esal from employee order by esal desc

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

Question Posted / sumalatha

Answer Posted / sumalatha

Is This Answer Correct ?

4 Yes

18 No

Please Help Members By Posting Answers For Below Questions

What is a composite primary key?

1099

What is use of package in pl sql?

1018

What is a temporal table?

935

How to pronounce postgresql?

1065

How can I see all tables in sql?

1080

How do you know if a relationship is 2nf?

949

what is the difference between blob and text? : Sql dba

1027

How many times can we commit in a loop?

1026

How do you delete a table?

1083

Determine if oracle date is on a weekend?

1042

Does sql full backup truncate logs?

1023

Can we group by two columns in sql?

1001

How exception handling is done in advance pl/sql?

985

What is the difference between alter trigger and drop trigger statements?

1116

What are the topics in pl sql?

977