Steven Low
Active member
- Joined
- Apr 14, 2005
- Messages
- 42
- Programming Experience
- 1-3
Resolved
Resolved
Resolved
Last edited:
select dept.deptno, dname, loc
from
emp
INNER JOIN
dept
ON
dept.deptno = emp.deptno
GROUP BY dept.deptno, dname, loc
Having MAX(NVL(emp.sal,9999999)) <= '3000'
order by dept.deptno