Oracle中的gruop by子句和having子句
??select dept_id,avg(salary) from s_emp group by dept_id having avg(salary)>2000;
发布时间: 2012-07-24 17:47:57 作者: rapoo
Oracle中的gruop by子句和having子句
??select dept_id,avg(salary) from s_emp group by dept_id having avg(salary)>2000;