var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Problem using a Nested Query on MySQL v 3.23.55
I got kinda lost here....
I tried to use the following nested query on MySQL v 3.23.55:
FROM Paquete AS P
WHERE P.id_paquete >= ALL (SELECT id_paquete FROM Paquete)
and the answer was:
You have an error in your SQL syntax near 'ALL ( SELECT id_paquete FROM Paquete )
works just fine.
The MySQL OnLine Manual (http://www.mysql.com/doc/en/ALL_subqueries.html) suggests it should work..
the page you cited --
is part of a larger section on subqueries
if you go up to this page --
so you want this --
Starting with MySQL 4.1, all subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific.
With earlier MySQL versions it was necessary to work around or avoid the use of subqueries
For MySQL versions prior to 4.1, most subqueries can be successfully rewritten using joins and other methods. See section 188.8.131.52 Rewriting Subqueries for Earlier MySQL Versions
from Paquete as P
join Paquete as P2
on P.id_paquete >= P2.id_paquete
having P.id_paquete = max(P2.id_paquete)