SQL中怎么查询阅读时间在营销活动推广时间一天内
create table push_reader as
select DISTINCT a.*,b.drop_dt from `sony_push detail` a
inner join sony_push b on a.camp_id = b.camp_id
where a.read_date>=b.drop_dt
and a.read_date<=date(b.drop_dt)+1;
create table push_reader as
select DISTINCT a.*,b.drop_dt from `sony_push detail` a
inner join sony_push b on a.camp_id = b.camp_id
where a.read_date>=b.drop_dt
and a.read_date<=date(b.drop_dt)+1;
相关推荐
查看15道真题和解析
愤怒的查理被升职:每个项目经历后面加关键成果:xxx, 项目经历要和岗位JD匹配,不是有多少项目经历都要写上的,挑选出是个岗位JD的,并且内容往岗位JD方面写,教育背景直接写 大学+专业+时间,一行就过去了。你是建筑投运营别人不看你本科建筑学的怎么样