Interested to Buy Any Domain ? << Click Here >> for more details...
I have one table :EID,Depid,ename,sal
I want to have max(sal) in each department.
- 5 Answers
- 9810 Views
- Microsoft, Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / omar
select e.department_id,max(e.salary)
from employees e
group by e.department_id
order by e.department_id desc;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to do paging with oracle?
How to find the duplicate rows count from employees table in oracle?
How to rename an existing table?
What is the disadvantage of User defind function?
How to use attributes of the implicit cursor in oracle?
How to convert a string to a date in oracle database?
What is a parameter file in oracle?
What is Undo Management Advisor in Oracle?
What are the uses of Database Trigger ?
Explain the difference between sap and oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What to do if the startbd.bat failed to start the xe instance?
What is the relation of a user account and a schema in oracle?
Explain overloading. Can functions be overloaded?
State and explain the different types of data models?
