select sal from( select rownum,e.* from empmaster e order by sal desc) wh

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

Question Posted / chandrasekar.ramasamy

Answer Posted / chandrasekar.ramasamy

select sal from( select rownum,e.* from empmaster e order
by sal desc) where rownum < 4

Is This Answer Correct ?

20 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is the use of function in sql?

1095

how do you tune the slow running queries in oracle db , explain the methodology

2799

how can you create an empty table from an existing table? : Sql dba

1154

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1223

What is trigger and types?

1026

What is percent sign in sql?

1283

What are sql injection vulnerabilities?

985

When should I use nosql database?

1008

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

1109

Enlist the data types that can be used in pl/sql?

1073

What is full join in sql?

992

Is sql sequential or random?

1037

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

1151

What are triggers and its uses?

1047

What is the use of %rowtype?

1041