I have this table:
Name Null? Type
-------------------------- -------- ------------
EMPLOYEENO NOT NULL NUMBER(4)
ENAME VARCHAR2(15)
JOB VARCHAR2(15)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER
COMM NUMBER
DEPTNO NUMBER(2).
I want to get the department with minimum employees who have a given job (for example all the employees with 'Analyst' job).
Can you please help me with the query?
See Question&Answers more detail:os