查询用户同一天下单的总金额
SELECT
Customer,
SUM(order_price)
FROM
(
SELECT
Customer,
order_price,
DATE_FORMAT(order_date, ‘%Y/%m/%d’) AS order_date
FROM
order_t
) a
GROUP BY
order_date,
Customer;
sql语句
最新推荐文章于 2020-02-24 14:25:52 发布
查询用户同一天下单的总金额
SELECT
Customer,
SUM(order_price)
FROM
(
SELECT
Customer,
order_price,
DATE_FORMAT(order_date, ‘%Y/%m/%d’) AS order_date
FROM
order_t
) a
GROUP BY
order_date,
Customer;