I've searched around quite a bit for an answer on this but I haven't found anything yet. As far as I understand the following is a valid SQL-92 query:
sqlite> select model from (select model,price from laptop where hdsize >= all (select
l.hdsize from laptop l)) MaxSize where MaxSize.price < 2500;
SQL error: near "all": syntax error
I'm trying to "Find the laptops that have the largest hard drive among
all the laptops in the database and cost less than than $2,500" (without
using aggregate functions). Whenever I try to use all in this way I
get this syntax error.
Thanks for your time.
-Evan
P.S. Here's another that fails:
sqlite> select model from pc intersect all select model from product;
SQL error: near "all": syntax error
--
/********************************************************************\
Evan McNabb: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
http://evan.mcnabbs.org
System Administrator, CS Department, BYU
GnuPG Fingerprint: 53B5 EDCA 5543 A27A E0E1 2B2F 6776 8F9C 6A35 6EA5
\********************************************************************/
pgp00000.pgp
Description: PGP signature
