请问:如何合并行,或者部分行转列 本帖最后由 freedcr 于 2010-03-26 16:23:54 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT T.POLICYINFO_ID, T.BRAND_ID, B_BRAND.BRANDNAME, T.DISTRICTCODE, '[' || T.DISTRICTCODE || ']' || B_DISTRICT.NAME DISTRICTNAME, T.STORETYPE_ID STORETYPE_ID, B_STORETYPE.NAME STORETYPENAME, MAX(DECODE(T.ISDRAW || T.ISEXC, '11', T.ID)) ID_11, MAX(DECODE(T.ISDRAW || T.ISEXC, '11', T.RATEVALUE)) VALUE_11, MAX(DECODE(T.ISDRAW || T.ISEXC, '10', T.ID)) ID_10, MAX(DECODE(T.ISDRAW || T.ISEXC, '10', T.RATEVALUE)) VALUE_10, MAX(DECODE(T.ISDRAW || T.ISEXC, '01', T.ID)) ID_01, MAX(DECODE(T.ISDRAW || T.ISEXC, '01', T.RATEVALUE)) VALUE_01, MAX(DECODE(T.ISDRAW || T.ISEXC, '00', T.ID)) ID_00, MAX(DECODE(T.ISDRAW || T.ISEXC, '00', T.RATEVALUE)) VALUE_00 FROM P_RATE T, B_BRAND, B_DISTRICT, B_STORETYPE WHERE T.BRAND_ID = B_BRAND.ID AND T.DISTRICTCODE = B_DISTRICT.DISTRICTCODE AND T.STORETYPE_ID = B_STORETYPE.ID GROUP BY T.BRAND_ID, T.DISTRICTCODE, T.STORETYPE_ID, POLICYINFO_ID, B_BRAND.BRANDNAME, B_DISTRICT.NAME, B_STORETYPE.NAME已经结出来了 Oracle触发器找错 64WIN7安装oracle10G 64问题 各位大侠 谁有oracle10g的教程??分享下 高手请进(谢谢!!)为什么无法启动oracleoraHome92Management Server? 用什么函数可以直接得到group by后的记录条数 请问如何关闭当前数据库,启动另外一个数据库 讨厌的协议适配器错误:ORA-12535: TNS 日期比较问题 oracle 主从配置 查询多张表中不为空的表(江湖救急) 求一oracle存储过程 请问下兄弟们复杂的在线时长的计算问题
T.BRAND_ID,
B_BRAND.BRANDNAME,
T.DISTRICTCODE,
'[' || T.DISTRICTCODE || ']' || B_DISTRICT.NAME DISTRICTNAME,
T.STORETYPE_ID STORETYPE_ID,
B_STORETYPE.NAME STORETYPENAME,
MAX(DECODE(T.ISDRAW || T.ISEXC, '11', T.ID)) ID_11,
MAX(DECODE(T.ISDRAW || T.ISEXC, '11', T.RATEVALUE)) VALUE_11,
MAX(DECODE(T.ISDRAW || T.ISEXC, '10', T.ID)) ID_10,
MAX(DECODE(T.ISDRAW || T.ISEXC, '10', T.RATEVALUE)) VALUE_10,
MAX(DECODE(T.ISDRAW || T.ISEXC, '01', T.ID)) ID_01,
MAX(DECODE(T.ISDRAW || T.ISEXC, '01', T.RATEVALUE)) VALUE_01,
MAX(DECODE(T.ISDRAW || T.ISEXC, '00', T.ID)) ID_00,
MAX(DECODE(T.ISDRAW || T.ISEXC, '00', T.RATEVALUE)) VALUE_00
FROM P_RATE T, B_BRAND, B_DISTRICT, B_STORETYPE
WHERE T.BRAND_ID = B_BRAND.ID
AND T.DISTRICTCODE = B_DISTRICT.DISTRICTCODE
AND T.STORETYPE_ID = B_STORETYPE.ID
GROUP BY T.BRAND_ID,
T.DISTRICTCODE,
T.STORETYPE_ID,
POLICYINFO_ID,
B_BRAND.BRANDNAME,
B_DISTRICT.NAME,
B_STORETYPE.NAME
已经结出来了