a query to select maxmun 3 salaries of employee table
- 12 Answers
- 21043 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
How to put more than 1000 values into an oracle in clause?
Design database draw er diagram for a certain scenario ?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to write a left outer join with the where clause in oracle?
How to select all columns of all rows from a table in oracle?
What is oracle latest version?
How to start an oracle instance?
How to use values from other tables in update statements using oracle?
