所有订单的件数分布mysql
MySQL中所有订单的件数分布可以通过以下代码实现:
SELECT COUNT(*) AS `count`, `quantity` FROM `orders` GROUP BY `quantity` ORDER BY `count` DESC;
MySQL中所有订单的件数分布可以通过以下代码实现:
SELECT COUNT(*) AS `count`, `quantity` FROM `orders` GROUP BY `quantity` ORDER BY `count` DESC;