mysql - 销售点定义

Question

我建立库存并管理库存+发票我有一张“发票”表

content: id 
customer_name
net_total
paid
due
ordre_date

我想显示每天、一周和几个月的所有 net_total

我使用这个查询

SELECT *, sum(net_total) as privé 
FROM invoice 
GROUP BY order_date 

但它并没有显示每天的所有 net_total

Answer 1

尝试:

SELECT DATE_FORMAT(order_date, '%Y%m%d') AS order_day, sum(net_total) AS privé FROM invoice GROUP BY order_day ORDER by order_day

由于 order_date 可能是包含小时、分钟的时间戳......并且您只想按天进行分组。