task_contentid in(select distinct(tx_id) from gis_qx_fw where YH_ID = '00000000000034') orsubstr(task_contentid,0,instr(task_contentid,'/')-1) in (select distinct(tx_id)from gis_qx_fw where YH_ID = '00000000000034'))这种写法会很慢的。你可以先把这些数据筛选出来放在一张temp表里面,然后再跑整个sql。...
如果可以用临时表的话先用临时表读取数据,在进行查询和分组动作,或者select to_char(A.createtime, 'YYYYMMDD'), count(*)from (select t1.createtime from ai_visit_record as t1 where createtime in ('2011-04-06','20...