how to retrieve the top 3 salaries of the table using rownum
Answer Posted / manivasan.s.,
select salary from salary_table
where rownum <4
order by salary desc
Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What are the operators in sql?
Is primary key always clustered index?
Explain the working of primary key?
Can you select everything, but 1 or 2 fields, without writer's cramp?
what is the difference between group by and order by in sql? : Sql dba
What is delimiter in pl sql?
What are stored procedures in mysql?
what is a control file ? : Sql dba
How does rowid help in running a query faster?
what is oracle database ? : Sql dba
What is varchar used for?
What is rank dense_rank and partition in sql?
What is full form of rtm?
What are sql procedures?
Can cursors be part of a trigger body?