MySQL 查询一个简单的表

Question

我的 table :

+----+---------+----------+--------+--------------+| id | size    | quantity | status | customers_id |+----+---------+----------+--------+--------------+| 12 | 10_feet | 3        | active |            0 || 13 | 10_feet | 3        | active |            0 || 14 | 10_feet | 2        | active |            0 || 15 | 14_feet | 5        | active |            0 || 16 | 14_feet | 2        | active |            0 || 17 | 14_feet | 2        | active |            0 || 18 | 17_feet | 2        | active |            0 || 19 | 17_feet | 2        | active |            0 || 20 | 24_feet | 3        | active |            0 |+----+---------+----------+--------+--------------+

Looking for query to show each size and a sum of the quantity.

10_feet  8   active14_feet  9   active17_feet  4   active24_feet  3   active

Query that I am using is

SELECT *, SUM(quantity)  FROM`trucks` GROUP BY size;

但它只显示

10_feet   3 active14_feet   5 active17_feet   2 active24_feet   3 active

Answer 1

试试这个:

select a.size,sum(a.qty),a.status from table a inner join table b on a.id=b.id group by a.size