select
factory_name,
sum(decode(to_char(给定天 ,'YYYYMMDD'),to_char(insert_date,'YYYYMMDD'),1,0)) as prod_count1,
sum(decode(to_char(给定天-1,'YYYYMMDD'),to_char(insert_date,'YYYYMMDD'),1,0)) as prod_count2
from
表
group by
factory_name
factory_name,
sum(decode(to_char(给定天 ,'YYYYMMDD'),to_char(insert_date,'YYYYMMDD'),1,0)) as prod_count1,
sum(decode(to_char(给定天-1,'YYYYMMDD'),to_char(insert_date,'YYYYMMDD'),1,0)) as prod_count2
from
表
group by
factory_name
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货