Oracle中的gruop by子句和having子句??select dept_id,avg(salary) from s_emp group by dept_id having a
Oracle中的gruop by子句和having子句
??select dept_id,avg(salary) from s_emp group by dept_id having avg(salary)>2000;
Oracle中的gruop by子句和having子句
??select dept_id,avg(salary) from s_emp group by dept_id having avg(salary)>2000;