MYSQL 统计语句

select sum(ordercount) from orders where teamId = 2 这样就行了~！！~如果Teamid 是字符类型的 就的用select sum(ordercount) from orders where teamId = '2'

select 商品名称,

sum(数量) as 总量,sum(金额) as 总金额,

sum(case 线号 when '1号线' then 数量 else 0 end) as 1号线数量,

sum(case 线号 when '2号线' then 数量 else 0 end) as 2号线数量,

sum(case 线号 when '3号线' then 数量 else 0 end) as 3号线数量,

sum(case 线号 when '4号线' then 数量 else 0 end) as 4号线数量,

sum(case 线号 when '1号线' then 金额 else 0 end) as 1号线金额,

sum(case 线号 when '2号线' then 金额 else 0 end) as 2号线金额,

sum(case 线号 when '3号线' then 金额 else 0 end) as 3号线金额,

sum(case 线号 when '4号线' then 金额 else 0 end) as 4号线金额

from

(

select 商品名称,线号,sum(数量) as 数量,sum(金额) as 金额

from Table1

group by 商品名称,线号

) T1

group by 商品名称

先找今天的订单

select * from order a where a.c_time >"2016-07-16 00:00:00" and a.c_time <"2016-07-17 00:00:00"

再根据 两个表的关联字段显示user表的会员数据

select * from

(select * from order a where a.c_time >"2016-07-16 00:00:00" and a.c_time <"2016-07-17 00:00:00") a

left jion

user b

on

a.user_id = b.id

---