I have one table :EID,Depid,ename,sal
I want to have max(sal) in each department.
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 to convert .db (extention) database file into .dmp (extention ) for oracle database ?
write a query that displays every Friday in a year with date?
can you call insert/update/delete in select statements. If yes how? If no what is the other way?
How remove data files before opening a database?
What is a data lock in oracle?
Describe varray?
20. Using a set operator, display the client number of all clients who have never placed an order.
Can we create more than one index on particular column?
How can Oracle users be audited?
What is Row Chaining ?
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
What is concurrency in oracle?