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

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

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,


What is index example?

0 Answers  


What types of commands can be executed in sql*plus?

0 Answers  


what is sql? : Sql dba

0 Answers  


What is difference between db2 and sql?

0 Answers  






What is a temporal data type?

0 Answers  


Does access use sql?

0 Answers  


how to create table with in the procedure or function?

2 Answers   Genpact, HCL,


How many unique keys can a table have?

0 Answers  


What is nosql example?

0 Answers  


What action do you have to perform before retrieving data from the next result set of a stored procedure ?

0 Answers   Microsoft,


What is the max nvarchar size?

0 Answers  


Categories