DEPTNO DNAME          LOC
---------- -------------- -------------
         0 ss             tt
         1 tt             ii
         2 yy             gg
         1 tt             uu
         0 smlee          insert




SQL>  select * from  dept a
   where 1 < (select count(deptno) from dept b  where a.deptno =b.deptno);  

    DEPTNO DNAME          LOC
---------- -------------- -------------
         0 ss             tt
         1 tt             ii
         1 tt             uu
         0 smlee          insert