摘要：
select t2.dep_no,t2.dep_name,t1,empCount,t2.empAvgAgefrom( select t.dep_no, count(t.emp_no) as empCount, avg(t.emp_age) empAvgAge, from employee t where t.emp_no < 80707999 group by t.dep_no)t1left join department t2 on t1.dep_no=t2.dep_no 阅读全文
posted @ 2008-12-06 18:08 小飞龙(Jack) 阅读(5439) 评论(0) 推荐(0)
浙公网安备 33010602011771号