这句是把上升和下跌10%的业务显示出来!
select wm_concat(type_name) as bb
from
(
select type_name,
trunc((sum(MON_USERCOUNT)-sum(LAST_MON_USERCOUNT))/sum(LAST_MON_USERCOUNT),2) as UpDownRate
from vw_OSS_SRV_INTEGR_STAT
where stat_type_id=1
and statedate=20120308
group by type_name
)
where updownrate >0.1 or updownrate <-0.1
BB
无线城市,社区,游戏,支付,音乐,门户,飞信