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 are the ddl commands?

953

What is a schema sql?

1058

Name the different types of indexes in sql and define them.

1077

Does postgresql run on the cloud?

1081

what is commit? : Sql dba

1029

What is an inner join sql?

957

What is the order of sql select?

992

How would you reference column values before and after you have inserted and deleted triggers?

1023

Is record in pl sql?

918

How does cross join work?

880

How does sql developer connect to oracle database?

953

What is the purpose of normalization?

997

how to escape special characters in sql statements? : Sql dba

973

How do you use a while loop in pl sql?

942

What are the three forms of normalization?

996