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 are views in sql?

962

What are all the different types of indexes?

1126

What is pivot table in sql?

1081

What are different types of functions in sql?

990

What is a join?

1046

Can we change the table name in sql?

925

What will you get by the cursor attribute sql%notfound?

1040

What is exception? What are the types of exceptions?

1060

how to create a test table in your mysql server? : Sql dba

989

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

949

How many sql databases can you have on one server?

1060

What is sql partition function?

1183

Does mysql_real_escape_string prevent sql injection?

937

Is left join inner or outer?

1002

What is update query?

961