... select 1 as val,'总支队比较' as text where 2 = '${grade}' union select 2 as val,'中大队比较' as text where 2 = '${grade}' union select 3 as val,'与其他支队比较' as text where 3 = '${grade}' union select 4 as val,'本支队下大中队比较' as text where 3= '${grade}' ...
case when 条件 then 结果1 else 结果2 end