如果我写:
SELECT * FROM `expense`
我去拿
2022-02-17 10 bread
2022-02-23 20 perfume
但如果我说:
SELECT expense_date, amount, description, sum(amount) as total
FROM expense
查询提供了最后一项。我怎样才能得到像我一样的东西呢?
SELECT *
我试过了
SELECT *, sum(amount) as total
FROM expense
但没有骰子: