选择出平均工资最低的部门和平均工资(mysql)
select depart,s from (SELECT depart ,avg(salary) s FROM test1 GROUP BY depart) aa where s=(select min(s) from (SELECT depart ,avg(salary) s FROM test1 GROUP BY depart) aa);
选择出平均工资最低的部门和平均工资(mysql)
select depart,s from (SELECT depart ,avg(salary) s FROM test1 GROUP BY depart) aa where s=(select min(s) from (SELECT depart ,avg(salary) s FROM test1 GROUP BY depart) aa);