Interested to Buy Any Domain ? << Click Here >> for more details...
a query to select maxmun 3 salaries of employee table
- 12 Answers
- 20716 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
Can I create users through internet explorer in oracle 10g?
What is the difference between alert log file and tarce file ?
Describe varray?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Explain a data segment?
Explain the truncate in oracle?
What is the recommended interval at which to run statspack snapshots, and why?
How to convert a string to a date in oracle database?
How will you differentiate between varchar & varchar2?
What is a Garbage Collection? and what is full recursive Garbage collection?
Calculate difference between 2 date / times in oracle sql?
How to calculate date and time differences in oracle?
Explain drop constraint oracle?
ABOUT IDENTITY?
