回答：语文、英语正常查询，数学写个子查询查询出最大日期，把日期等于最大日期，然后两段UNION ALL就行了

回答：在Navicat里先查询一行所有数据，复制结果集字段名，粘贴在新建查询里，把不要的字段删除，批量替换掉字段之间的空格就行了

回答：[图片]

回答：select substr('XDI465T2S-62XD-0-0-0-16',1,instr('XDI465T2S-62XD-0-0-0-16','-',1,2)-1) from dual

回答：设置提交条件

回答：select regexp_replace(b.org,'供电所',null) as org,a.cons_num  cons_num_6,b.cons_num  cons_num_12,a.cons_num+b.cons_num total_num,a.ordfrom (select org ,pre_org  , sum(cons_num) cons_num,case when org = '福州' then 1 when org = '厦门' then 2 when org = '莆田' then 3when org = '泉州' then 4 when org = '漳州' then 5 when org = '龙岩' then 6when org = '三明' then 7 when org = '南平' then 8 when org = '宁德' then 9end ordfrom (select  case    when time_segment in ('12-20h', '20-24h','24h以上') then '12h以上'    else time_segment  end time_segment  , cons_num  , org  ,pre_orgfrom rc_arp_lv2_time_segment_cons_2where 1=1 and stat_time = (select max(stat_time) from rc_arp_lv2_time_segment_cons_2)) x1where time_segment = '6-12h'group by org, time_segment,pre_org) aleft join (select org  ,pre_org  , sum(cons_num) cons_numfrom (select  case    when time_segment in ('12-20h', '20-24h','24h以上') then '12h以上'    else time_segment  end time_segment  , cons_num  , org  ,pre_orgfrom rc_arp_lv2_time_segment_cons_2where 1=1 and stat_time = (select max(stat_time) from rc_arp_lv2_time_segment_cons_2))x1where time_segment = '12h以上'group by org, time_segment,pre_org) b on a.org = b.orgorder by a.ord,a.org基本是这样的

回答：where nvl(字段，0)<>0 ,oracle用nvl，SQL server用isnull,mysql用ifnull就行

回答：setTimeout(function() {       //隐藏报表块report0的滚动条（此报表块名为report0，根据具体情况修改）    $("div").find(".frozen-north").css({        'overflow-x':'hidden',        'overflow-y':'hidden'    });    $("div").find(".frozen-center").css({        'overflow-x':'hidden',        'overflow-y':'hidden'    });    _g().getWidgetByName('report0').startMarquee()},1000);你用这个试下

回答：填报校验里写公式 if(len(a)>0,len(b)>0,"b不能为空")

回答：就是除了你avg里的字段，其他都得group by