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

what is a relationship and what are they? : Sql dba

1027

what is offset-fetch filter in tsql? : Transact sql

893

What is nvarchar max in sql?

960

What is nosql db?

926

What is the use of nvl function?

1128

How many triggers can be applied to a table?

995

Does inner join remove duplicates?

888

Where can I learn sql for free?

933

What are the different types of sql commands?

1065

What is the purpose of my sql?

903

Which command is used to delete a trigger?

1263

What is data control language (dcl)?

1047

how to create a table index in mysql? : Sql dba

988

what is collation? : Sql dba

1079

What are the advantages of indexing?

929