Delete those records where no of employees in a particular department is less than 3.

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 1835
SQL>delete from emp where deptno=(select deptno from emp
group by deptno having count(deptno)<3);

Comments or Responses

Login to post response