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
- 9811 Views
- Microsoft, Oracle, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vengalrao
Dear Friends,
Depends upon table u can pick one max value is possible,one
table u cannot pick max value of all columans , then u can
refer one any ne column
select depid,max(sal) from <table name> group by depid;
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / narasimha
select e.eid,e.sal,e.depid,e.ename,e.sal from emp e
where 1>(select count(*) from emp w where e.sal<w.sal and
e.depid=w.depid) order by e.deptno asc
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / venkat
select * from emp_test where sal IN(select max(sal) from
emp_test group by deptno)
| Is This Answer Correct ? | 1 Yes | 6 No |
How many memory layers are in the oracle shared pool?
Can multiple cursors being opened at the same time?
What is object data modeling?
How to view all columns in an existing table?
primary key is foreign key for the same table?
How to call a stored function with parameters?
Difference between inner join vs where ?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
What happens to the current transaction if a ddl statement is executed?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How to Select second Maximum salary in a Table ?
How to use attributes of the implicit cursor in oracle?
Oracle General 
