sql查询

一、  

   select d.shop_id as shopId, sum(d.traffic_out_of_door) as humanFlow,

sum(d.in_store_flow) as inStoreFlow,
sum(d.human_flow) as humanFlow,
FORMAT(d.in_store_flow/d.human_flow,3) as inStoreRate ,
sum(new_customers) as newCustomers,
sum(old_customers) as oldCustomers
from t_stat_day d where d.shop_id in
(4843, 4844, 4846, 4768, 4845, 4850, 4765)
and
d.stat_time >= '2017-04-01'
and d.stat_time <= '2017-04-31'

group by d.shop_id;

上面的sql查询到两条结果如下

：

二、

     select d.shop_id as shopId, sum(d.traffic_out_of_door) as humanFlow,
sum(d.in_store_flow) as inStoreFlow,
sum(d.human_flow) as humanFlow,
FORMAT(d.in_store_flow/d.human_flow,3) as inStoreRate ,
sum(new_customers) as newCustomers,
sum(old_customers) as oldCustomers
from t_stat_day d where d.shop_id in
(4843, 4844, 4846, 4768, 4845, 4850, 4765)
and
d.stat_time >= '2017-04-01'
and d.stat_time <= '2017-04-31'
;

上面的sql查到一条数据如下：

其中各项数据是第一个sql的结果之和。