Sum and Limit?

[Kaelyn]

Hi,
My query sums up value of the field and I need to sum up a certain range accomplished by the LIMIT instruction but mysql sum up everything and LIMIT has been disregarded.

select
sum(quantity)
from
stock_card
limit 0,2;

Any help is greatly appreciated.
Thanks, -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Sague]

It looks as if the LIMIT clause affects only the number of rows returned, and this query in fact only returns one row. So, try as below:

SELECT sum(quantity)
FROM (SELECT quantity
FROM stock_card
LIMIT 0,2
) AS subquery; -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --