把你表的字段贴出来啊
没有字段,猜着写的,意思是这样的
select 部门号,
case when maxs-mins>2000 then 'H'
when maxs-mins<2000 and maxs-mins>=1000 then 'M'
when maxs-mins<1000 then 'L'
end as flag
from
(select 部门号,max(工资) as maxs ,min(工资)as mins from table_name group by 部门号)
温馨提示:内容为网友见解,仅供参考