Interested to Buy Any Domain ? << Click Here >> for more details...
a query to select maxmun 3 salaries of employee table
- 12 Answers
- 20346 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
Answer Posted / ron
if you need to select by department then analytic function
is more readable:
1. use row_number() partition by dept order by sal desc as rn,
2. in where clause choose rn <4;
you can use rank() instead; if 2 or more employees have same
salary.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Explain what are synonyms used for?
Please explain oracle data types with examples?
What is analyze command used for?
What is Virtual Private Database in Oracle?
Explain the use of full option in exp command.
Why is oracle database so popular?
How to list all user accounts in oracle?
How to estimate disk space needed for an export job?
Is oracle an open source?
Can multiple cursors being opened at the same time?
query optmization techniques and quwry analyser+projects+ppts
How to get a list of all user accounts in the database?
What suggestions do you have to reduce the network traffic?
What is oracle server autotrace in oracle?
What happens to the current transaction if the session is killed?
