MySQL选择结果的总和为LIMIT [英] MySQL select SUM of results with a 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的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！