how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 36975 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / raveendran
SELECT EMP_BASICS,ROWNUM FROM EMPLOYEE_MASTER WHERE
EMP_BASICS IS NOT NULL AND ROWNUM<=3 ORDER BY EMP_BASICS
DESC
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a join?
What is the usage of the distinct keyword?
How to assign sql query results to pl sql variables?
What is the least restrictive isolation level? : Transact sql
What are secondary keys?
What is an inconsistent dependency?
What is the most common sql injection tool?
What is left join example?
how to do backup entire database? : Transact sql
What is using in sql?
What is difference sql and mysql?
How can a pl sql block be executed?
Is merge a dml statement?
What is the starting oracle error number?
Where is pl sql used?
