Monday, 9 March 2015

SQL Query to Display the department Number with more than ten employees in each department?

select deptno, count(*) from emp group by deptno having count (*) >10

No comments:

Post a Comment