用一条sql查询平均工资，最高工资，最低工资，10号部门最高工资，20号部门最高工资

Question

用一条sql查询平均工资，最高工资，最低工资，10号部门最高工资，20号部门最高工资

Answer 1

• select avg(Pay) as Pay from T_Depart
  select max(Pay) as Pay from T_Depart
  select DepartNo ,max(Pay) as Pay from T_Depart where DepartNo =10 GROUP BY DepartNo 
  select DepartNo ,max(Pay) as Pay from T_Depart where DepartNo =20 GROUP BY DepartNo