select * from (
select '1' as 月份 bgan1 from 表 union all
select '2' as 月份,bgan2 from 表 union all
select '3' as 月份,bgan3 from 表 union all
select '4' as 月份 bgan4 from 表 union all
select '5' as 月份 bgan5 from 表 union all
select '6' as 月份 bgan6 from 表 union all
select '7' as 月份 bgan7 from 表 union all
select '8' as 月份 bgan8 from 表 union all
select '9' as 月份 bgan9 from 表 union all
select '10' as 月份 bgan10 from 表 union all
select '11' as 月份 bgan11 from 表 union all
select '12' as 月份 bgan12 from 表
)t1
where
xxxxxx=xxxx