MySQL Forums
Forum List  »  New in 4.1: Subqueries

LIMIT in subqueries
Posted by: Stephen Booth
Date: February 09, 2005 07:51PM

I just tried the following query:

select sum(sorties) from missions where sorties in (select sorties from missions limit 0,2);

and got the result

ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

Is there another way I could accomplish a sum on a subset of rows from a table?

Other than this, the subqueries seem to work great!

Options: ReplyQuote

Written By
LIMIT in subqueries
February 09, 2005 07:51PM
December 17, 2008 03:15PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.