LIMIT in subqueries
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!
Subject
Views
Written By
Posted
LIMIT in subqueries
27992
February 09, 2005 07:51PM
12867
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.