1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / deva

Answers were Sorted based on User's Feedback



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

Answer / vivek dubey

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

Is This Answer Correct ?    24 Yes 42 No

Post New Answer

More SQL PLSQL Interview Questions

What is the maximum number of columns in sql table?

0 Answers  

What is delete command in sql?

0 Answers  

What are the query optimization techniques?

0 Answers  

what is explain plan?, given an example...

3 Answers   Polaris,

in table there r so many rows write a query which two rows r updated last two day befor?

3 Answers   Exilant,




What is the diffrence between IN and EXISTS.which one is faster.

3 Answers   Infogain,

Can unique keys be null?

0 Answers  

What is sql used for?

0 Answers  

How to use sql statements in pl/sql?

0 Answers  

function can return multiple value?how give give sample coding

2 Answers   3i Infotech, CTS, Excelity Global, UHG,

What is sql key?

0 Answers  

How do I copy a table in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories