学习以促进工作--技能提高篇之Sql

select case when count(mgr)!=0 then count(mgr) else 0 end cnt,mgr from emp group by mgr,JOB;
SELECT * FROM USER_COL_COMMENTS ;