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 sqlerrm?

918

explain about mysql and its features. : Sql dba

1002

Is subquery faster than join?

999

What is trigger explain with example?

1015

How to test for null values?

1023

What is the purpose of cursors in pl/sql?

1122

How can we store rows in PL/SQL using array?

1202

How long does it take to learn pl sql?

1044

What is varray in pl sql?

1056

What are different clauses used in sql?

1103

How do I pipe the output of one isql to another?

989

How do you run a query?

979

What is an invalid partition table?

1010

How many scalar data types are supported in pl/sql?

1027

Which is faster joins or subqueries?

969