select /*+index(a idx_city_code)*/ 1385694000 as begin_time,
1385694300 as end_time,
'南京' as region_city,
'111450' as id,
count(distinct a.im) as count
from table1 a
where begin_time >= 1385694000
and begin_time < 1385694300
and city_code = 25
and cid in (1375333355);
1385694300 as end_time,
'南京' as region_city,
'111450' as id,
count(distinct a.im) as count
from table1 a
where begin_time >= 1385694000
and begin_time < 1385694300
and city_code = 25
and cid in (1375333355);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货