.Net  
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 ;
posted on 2007-06-27 22:09 东方新秀 阅读(...) 评论(...) 编辑 收藏
 
Copyright © 东方新秀 Powered by: 博客园 模板提供:沪江博客