select salary_column from salary_table where rownum<4 order by salary

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

Question Posted / vivek dubey

Answer Posted / vivek dubey

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

Is This Answer Correct ?

24 Yes

42 No

Please Help Members By Posting Answers For Below Questions

Can you load data into multiple tables at once? : aql loader

1120

what are the disadvantages of mysql? : Sql dba

1210

Write the command to remove all players named sachin from the players table.

1230

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1126

what is the functionality of the function htmlentities? : Sql dba

1008

What is posting?

1086

What is the difference between microsoft access and sql server?

1108

what is a constraint? Tell me about its various levels. : Sql dba

1049

what is data manipulation language? : Sql dba

1071

Show the cursor attributes of pl/sql.

1102

Can we use rowid as primary key?

1046

what does the t-sql command ident_current does? : Transact sql

1048

Can we perform dml in function?

1135

What does dml mean?

1043

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1244