| ceoModel_id | Qt_ceoModel |
|:----------- |------------:|
| 2 | 1 |
| 3 | 2 |
| 4 | 2 |
uj5u.com熱心網友回復：
select ceoModel_id,
count(ceoModel_id) as Qt_ceoModel
from inventory_ceos
group by ceoModel_id;
這行得通嗎？
uj5u.com熱心網友回復：
您需要 GROUP BY ceoModel_id
CREATE tABLE inventory_ceos (ceoModel_id int)
INSERT INTO inventory_ceos VALUES(1),(2),(2),(3),(3)
SELECT ceoModel_id, COUNT(*) AS Qt_ceoModel FROM inventory_ceos GROUP BY ceoModel_idceoModel_id | Qt_ceoModel ----------: | ----------: 1 | 1 2 | 2 3 | 2
db<>在這里擺弄
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/443189.html