select CHANNEL_KIND, '全省' as cityid,stat_day as stat_day, sum(MOBILETOTAL_DEVNUM) MOBILETOTAL_DEVNUM, sum(DEVNUM_2G) DEVNUM_2G, sum(TOTAL3G_DEVNUM) TOTAL3G_DEVNUM, sum(NETCARD3G_DEVNUM) NETCARD3G_DEVNUM, sum(CONTRACT3G_DEVNUM) CONTRACT3G_DEVNUM, sum(CARD3G_DEVNUM) CARD3G_DEVNUM, sum(BROADBAND_DEVNUM) BROADBAND_DEVNUM, sum(FIXED_DEVNUM) FIXED_DEVNUM, sum(OTHER_DEVNUM) OTHER_DEVNUM, sum(TOTAL_DEVNUM) TOTAL_DEVNUM from V_SALEMAN_MANVIEW_DEVELOPDAY where 1=1 and stat_day>= '2011-08-15' and channel_kind <>'26' and cityid<>'0524' and manid ='admin' group by CHANNEL_KIND order by to_number(channel_kind)
解决方案 »
- 关于<s:iterator>输出标签与js更改标签属性问题.
- 深入理解Java虚拟机
- 提取网页中的图片
- 搞了一年Java web开发,转行搞手机客户端开发???
- iframe嵌入外网
- hibernate中级联操作对象的问题
- 【急!!!】如何在struts的Action中取realPath问题 ---在线等
- Cannot create PoolableConnectionFactory错误
- [TOMCAT]为什么webapps/examples/.../classes/下的servlet可以运行,自己webapps/myApp/../classes的却不行,烦闷!
- 关于WSDL,AXIS,ETTK和WEBSERVICE的问题
- log4j突然不出日志了
- 有关mybatis多参数的问题
select CHANNEL_KIND, '全省' as cityid,stat_day as stat_day, 你按照 CHANNEL_KIND 来分组、那么其他的东西就都要是聚合函数、除非你在把你不是聚合函数的查询项添加到分组条件当中去group by CHANNEL_KIND,'全省',stat_day