MySQL select SUM of results with a LIMIT(MySQL 选择具有 LIMIT 的结果的总和)
本文介绍了MySQL 选择具有 LIMIT 的结果的总和的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我有一张桌子，上面摆满了上述物品的物品和价格.我想获取价格最高的 3 件商品的总和.
I have a table full of items and prices for said items. I would like to grab the SUM of the 3 highest priced items.
我想也许 SELECT SUM(items.price) FROM items ORDER BY items.price LIMIT 3 但这似乎没有奏效.这可能吗?谢谢！
I thought perhaps SELECT SUM(items.price) FROM items ORDER BY items.price LIMIT 3 but that does not seem to do the trick. Is this possible? Thanks!
推荐答案
select sum(price) from (select items.price from items order by items.price desc limit 3) as subt;
这篇关于MySQL 选择具有 LIMIT 的结果的总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！
