MySQL Forums :: New in 4.1: Subqueries :: LIMIT in subqueries
Re: LIMIT in subqueries
Posted by: Alan Rabello ()
Date: December 17, 2008 03:15PM
A simple workaround:
select sum(sorties) from missions where sorties in (select * from (select sorties from missions limit 0,2) alias);
select sum(sorties) from missions where sorties in (select * from (select sorties from missions limit 0,2) alias);
| Subject | Views | Written By | Posted |
|---|---|---|---|
| LIMIT in subqueries | 19293 | Stephen Booth | 02/09/2005 07:51PM |
| Re: LIMIT in subqueries | 9571 | Alan Rabello | 12/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.
© 2013, Oracle Corporation and/or its affiliates