Select count of employee in each department where count greater than 3?

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 1199
SQL>select count(*) from emp group by deptno having count(deptno)>3

Comments or Responses

Login to post response