帮忙看看:
Select qh, Oper_Type_No as Oper_Code, sum(Succ_Times) as Succ_Times,
sum(Fail_Times) as Failed_Times, sum(Happen_Times) as Total_Times,
to_char( sum(Fail_Times) ) as Failed_Flag FROM worktab
Where Work_Date > '20031101' and Work_Date < '20031101'
and ( Oper_Type_No = '0' or Oper_Type_No = '2' or Oper_Type_No = '13'
or Oper_Type_No = '15' or Oper_Type_No = '14' or Oper_Type_No = '56'
or Oper_Type_No = '160' or Oper_Type_No = '10' or Oper_Type_No = '37'
or Oper_Type_No = '38' or Oper_Type_No = '39' or Oper_Type_No = '131'
or Oper_Type_No = '26' or Oper_Type_No = '27' or Oper_Type_No = '30'
or Oper_Type_No = '132' or Oper_Type_No = '24' or Oper_Type_No = '25'
or Oper_Type_No = '93' or Oper_Type_No = '19' or Oper_Type_No = '20'
or Oper_Type_No = '21' or Oper_Type_No = '55')
and ( qh = '24' or qh = '411' or qh = '412' or qh = '413'
or qh = '414' or qh = '415' or qh = '416' or qh = '417'
or qh = '418' or qh = '419' or qh = '410' or qh = '421'
or qh = '427' or qh = '429' or qh = '00' or qh = '****')
and Called Like '%122%' Group by qh, Oper_Type_No
UNION All
SELECT qh, Oper_Type as Oper_Code, Count(*) as Succ_Times, Count(*) as Failed_Times,
Count(*) as Total_Times, Etc1 as Failed_Flag
From work_Log
Where to_char(Start_Time, 'yyyymmddhh24') >= '2003110108'
and to_char(Start_Time, 'yyyymmddhh24') <= '2003110111'
and to_char(Start_Time, 'yyyy') = '2003'
and ( Oper_Type = '0' or Oper_Type = '2' or Oper_Type = '13'
or Oper_Type = '15' or Oper_Type = '14' or Oper_Type = '56' or Oper_Type = '160'
or Oper_Type = '10' or Oper_Type = '37' or Oper_Type = '38' or Oper_Type = '39'
or Oper_Type = '131' or Oper_Type = '26' or Oper_Type = '27' or Oper_Type = '30'
or Oper_Type = '132' or Oper_Type = '24' or Oper_Type = '25' or Oper_Type = '93'
or Oper_Type = '19' or Oper_Type = '20' or Oper_Type = '21' or Oper_Type = '55')
and ( qh = '24' or qh = '411' or qh = '412' or qh = '413' or qh = '414'
or qh = '415' or qh = '416' or qh = '417' or qh = '418' or qh = '419'
or qh = '410' or qh = '421' or qh = '427' or qh = '429' or qh = '00' or qh = '****')
and Called Like '%122%' and WorkDate = '01' Group by qh, Oper_Type, Etc1
Select qh, Oper_Type_No as Oper_Code, sum(Succ_Times) as Succ_Times,
sum(Fail_Times) as Failed_Times, sum(Happen_Times) as Total_Times,
to_char( sum(Fail_Times) ) as Failed_Flag FROM worktab
Where Work_Date > '20031101' and Work_Date < '20031101'
and ( Oper_Type_No = '0' or Oper_Type_No = '2' or Oper_Type_No = '13'
or Oper_Type_No = '15' or Oper_Type_No = '14' or Oper_Type_No = '56'
or Oper_Type_No = '160' or Oper_Type_No = '10' or Oper_Type_No = '37'
or Oper_Type_No = '38' or Oper_Type_No = '39' or Oper_Type_No = '131'
or Oper_Type_No = '26' or Oper_Type_No = '27' or Oper_Type_No = '30'
or Oper_Type_No = '132' or Oper_Type_No = '24' or Oper_Type_No = '25'
or Oper_Type_No = '93' or Oper_Type_No = '19' or Oper_Type_No = '20'
or Oper_Type_No = '21' or Oper_Type_No = '55')
and ( qh = '24' or qh = '411' or qh = '412' or qh = '413'
or qh = '414' or qh = '415' or qh = '416' or qh = '417'
or qh = '418' or qh = '419' or qh = '410' or qh = '421'
or qh = '427' or qh = '429' or qh = '00' or qh = '****')
and Called Like '%122%' Group by qh, Oper_Type_No
UNION All
SELECT qh, Oper_Type as Oper_Code, Count(*) as Succ_Times, Count(*) as Failed_Times,
Count(*) as Total_Times, Etc1 as Failed_Flag
From work_Log
Where to_char(Start_Time, 'yyyymmddhh24') >= '2003110108'
and to_char(Start_Time, 'yyyymmddhh24') <= '2003110111'
and to_char(Start_Time, 'yyyy') = '2003'
and ( Oper_Type = '0' or Oper_Type = '2' or Oper_Type = '13'
or Oper_Type = '15' or Oper_Type = '14' or Oper_Type = '56' or Oper_Type = '160'
or Oper_Type = '10' or Oper_Type = '37' or Oper_Type = '38' or Oper_Type = '39'
or Oper_Type = '131' or Oper_Type = '26' or Oper_Type = '27' or Oper_Type = '30'
or Oper_Type = '132' or Oper_Type = '24' or Oper_Type = '25' or Oper_Type = '93'
or Oper_Type = '19' or Oper_Type = '20' or Oper_Type = '21' or Oper_Type = '55')
and ( qh = '24' or qh = '411' or qh = '412' or qh = '413' or qh = '414'
or qh = '415' or qh = '416' or qh = '417' or qh = '418' or qh = '419'
or qh = '410' or qh = '421' or qh = '427' or qh = '429' or qh = '00' or qh = '****')
and Called Like '%122%' and WorkDate = '01' Group by qh, Oper_Type, Etc1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货