问题描述
- SQL ora-00933问题 没有正确结束
-
select to_date('2015-08-01','yyyy-mm-dd') as startdate,to_date('2015-08-07','yyyy-mm-dd') as enddate,a.channel_name,a.list_type,a.product_name ,b.bc,a.ac,sysdate
from
(select count(1) as ac,(case when se.channel_name is null then '空' else se.channel_name end) as channel_name,se.list_type,se.product_name from sx_list_send se where se.send_flag='Y' and to_char(se.send_time,'yyyy-mm-dd') >= '2015-08-01' and to_char(se.send_time,'yyyy-mm-dd') <= '2015-08-07'
group by se.channel_name,se.list_type,se.product_name order by se.channel_name,se.list_type,se.product_name) a,
(select count(1) as bc,**(case when sen.channel_name is null then '空' else sen.channel_name end) as channel_name**,sen.list_type,sen.product_name from sx_list_send sen where to_char(sen.send_time,'yyyy-mm-dd') >= '2015-08-01' and to_char(sen.send_time,'yyyy-mm-dd') <= '2015-08-07'
group by sen.channel_name,sen.list_type,sen.product_name order by sen.channel_name,sen.list_type,sen.product_name) b
where a.channel_name=b.channel_name and a.list_type=b.list_Type and a.product_name = b.product_name
解决方案
解决方案二:
已经结束了 电脑抽筋
时间: 2024-08-03 19:40:53