Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 42830 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / k.thrilok kumar
select rownum, sal from (select * from emp order by sal
desc) where rownum<=3
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What are the different dml commands in sql?
What is the difference between delete and truncate commands?
How do you pronounce sql?
What is a variable in sql?
Why do we use sql constraints?
How do you clear the screen in sql?
Is sql developer case sensitive?
What are the triggers associated with image items?
What is full join?
Can we join same table in sql?
What is sql clause?
Why do we need unique key in a table?
How do I view tables in mysql?
How can I change database name in sql?
