看看这个。
将查询更改为：
SET @rank=0;SELECt @rank:=@rank+1 AS rank, itemID, COUNT(*) as ordercount FROM orders GROUP BY itemID ORDER BY ordercount DESC;SELECT @rank;
最后选择是您的数量。
看看这个。
将查询更改为：
SET @rank=0;SELECt @rank:=@rank+1 AS rank, itemID, COUNT(*) as ordercount FROM orders GROUP BY itemID ORDER BY ordercount DESC;SELECT @rank;
最后选择是您的数量。
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
