Interested to Buy Any Domain ? << Click Here >> for more details...
a query to select maxmun 3 salaries of employee table
- 12 Answers
- 19837 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 overloading. Can functions be overloaded?
Explain table?
How does Oracle guarantee data integrity of data changes?
In which language oracle has been developed?
State any two functions of oracle?
What are advantages of dateset in datastage?
What are the attributes of the cursor?
What is the data type of dual table?
Explain a private synonyms?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How to select an oracle system id (sid)?
Difference between oracle's plus (+) notation and ansi join notation?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What is Undo Management Advisor in Oracle?
Explain view?
