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

What are the two characteristics of a primary key?

974

What is primary key and unique key?

1119

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2014

Name three sql operations that perform a sort.

1010

What is sql scripting?

1116

What are the different types of database management systems?

1001

How to take user input in pl sql?

1163

what is normalization? : Sql dba

1082

What is sql*loader and what is it used for? : aql loader

1174

What is left inner join in sql?

1042

What is the difference between delete and truncate statement in sql?

1069

Does sql require a server?

1011

What is the difference between a query and a report?

975

what are date and time data types? : Sql dba

983

What are two statement types in sql?

1100