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

Define the select into statement.

1112

What is the maximum number of columns in sql table?

1231

How can we make an if statement within a select statement?

1069

What are different types of tables in sql?

1052

Is keyword pl sql?

1057

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1288

What is sql resultset?

1043

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

1049

what is the use of set statement in tsql? : Transact sql

1063

How delete a row in sql?

1043

Can we write dml inside a function in sql server?

1004

What is the use of & in pl sql?

1099

Is left join faster than join?

1096

What is the use of <> sql?

1039

How do I edit a trigger in sql developer?

1054