Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 40635 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / chandrasekar.ramasamy
select sal from( select rownum,e.* from empmaster e order
by sal desc) where rownum < 4
| Is This Answer Correct ? | 20 Yes | 7 No |
Post New Answer View All Answers
How many parts of a pl sql block are optional?
What do you mean by query optimization?
What are the subsets of sql?
what is the use of double ampersand (&&) in sql queries?
What does desc stand for?
How do I add a primary key to a table?
How do I run sql?
What has stored procedures in sql?
Show how functions and procedures are called in a pl/sql block.
How does left join work in sql?
How would you pass hints to the sql processor?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What are the different types of functions in sql?
Where is pl sql used?
How does a covering index work?
