how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 36985 Views
- Oracle, I also Faced
- E-Mail Answers
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 is the sql query to display the current date?
What is a string data type in sql?
What is pl sql in oracle?
What is pls_integer in pl sql?
What are all the different types of indexes?
What are the different types of a subquery?
How do I trace sql profiler?
Is vs as in pl sql?
How many types of triggers are there in pl sql?
What is a heap in sql?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
How do you determine the current isolation level? : Transact sql
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
Can we use pl sql in mysql?
What is a sql instance vs database?
