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 are its different types of dbms?

1002

how to install mysql? : Sql dba

1106

what are numeric data types? : Sql dba

1060

What are different types of statements supported by sql?

1165

Is it possible to create startup or shutdown trigger for on-schema?

1021

Explain normalization and what are the advantages of it?

951

Does inner join return duplicate rows?

976

Explain table and field in sql?

1060

What is materialized view in sql?

918

Which is faster count (*) or count 1?

1030

Is keyword pl sql?

993

What is mutating sql table?

1107

how are mysql timestamps seen to a user? : Sql dba

1139

how many sql dml commands are supported by 'mysql'? : Sql dba

1120

How can I tell if sql is running?

1064