select salary from salary_table where rownum <4 order by salary desc

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

Question Posted / manivasan.s.,

Answer Posted / manivasan.s.,

select salary from salary_table
where rownum <4
order by salary desc

Is This Answer Correct ?

2 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Is stored procedure faster than query?

913

what is 'mysqldump'? : Sql dba

1046

How to use sql statements in pl/sql?

1050

What is sqlerrm?

880

What is sql entity?

1027

What is the difference between rollback and rollback to statements?

1012

How do you modify a table in sql?

1060

What pl/sql package consists of?

1029

What is the sql*loader? : aql loader

1003

What is sql profiler in oracle?

1012

Are views faster than queries?

915

what is oltp (online transaction processing)? : Sql dba

1010

Can sql developer connect to db2?

981

What is an example of translating a date into julian format?

1035

What can sql server reporting services do?

1051