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

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1105

How do you remove duplicates without using distinct in sql?

963

Explain how exception handling is done in advance pl/sql?

985

Is sqlexception checked or unchecked?

950

What is sql used for?

1100

what is dbms? : Sql dba

974

what does it mean to have quoted_identifier on? : Sql dba

1132

What is spool?

1034

What are the types of variables use in pl sql?

1025

What is offset in sql query?

1093

What steps server process has to take to execute an update statement?

963

How do I run sql profiler?

1051

How many joins in sql?

983

Can variables be used in sql statements?

1019

What are the uses of sysdate and user keywords?

1086