ibtaits动态列查询显示

最新推荐文章于 2017-11-21 20:05:00 发布

原创最新推荐文章于 2017-11-21 20:05:00 发布 · 478 阅读

0 ·

CC 4.0 BY-SA版权

ibtatis 专栏收录该内容

1 篇文章

订阅专栏

本文深入探讨了移动基站的运营情况，通过数据集分析了不同城市、类型和业务类型的基站功率平均值、最大值和最小值，同时根据年份、月份和季度进行了筛选，提供了关键指标的统计概览。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<select id="selMobileStationStandard" resultClass="eoms.power.model.MSStandardPowerModel"
parameterClass="java.util.Map" remapResults="true">
select to_char(firstday,'yyyy') as date_str,
<isNotEmpty prepend="" property="cityPar">
a.unit as city,
</isNotEmpty>
<isNotEmpty prepend="" property="stPar">
a.pr_type as station_type,
</isNotEmpty>
<isNotEmpty prepend="" property="btPar">
a.jz_lx as biz_type,
</isNotEmpty>
avg(b.degrees) as power_avg,
max(b.degrees) as power_hig,
min(b.degrees) as power_low,
count(a.jz_name) as station_total
from mobile_info_his a,copy_info_month b
where a.datestamp =b.firstday
and b.jz_type = '移动基站'
and a.jz_name=b.jz_name(+)
and a.unit=b.city(+)
and a.county=b.county(+)
<isNotEmpty property="year_par" prepend="and">
to_number(to_char(a.datestamp,'yyyy'))in ($year_par$)
</isNotEmpty>
<isNotEmpty property="month_par" prepend="and">
to_number(to_char(a.datestamp,'mm'))in ($month_par$)
</isNotEmpty>
<isNotEmpty property="season_par" prepend="and">
to_number(to_char(a.datestamp,'q'))in ($season_par$)
</isNotEmpty>
<isNotEmpty property="city_par" prepend="and">
a.unit in ($city_par$)
</isNotEmpty>
<isNotEmpty property="station_par" prepend="and">
a.pr_type in ($station_par$)
</isNotEmpty>
<isNotEmpty property="biz_par" prepend="and">
a.jz_lx in ($biz_par$)
</isNotEmpty>
group by to_char(firstday,'yyyy')
<isNotEmpty prepend="" property="cityPar">
,a.unit
</isNotEmpty>
<isNotEmpty prepend="" property="stPar">
,a.jz_lx
</isNotEmpty>
<isNotEmpty prepend="" property="btPar">
, a.pr_type
</isNotEmpty>
order by to_char(firstday,'yyyy')
<isNotEmpty prepend="" property="cityPar">
,a.unit
</isNotEmpty>
<isNotEmpty prepend="" property="stPar">
,a.jz_lx
</isNotEmpty>
<isNotEmpty prepend="" property="btPar">
, a.pr_type
</isNotEmpty>

</select>