MAX/MIN Question

[wel51x]

is the following illegal?

SELECT `Make` , `Model` , `Price`
FROM `inventory`
WHERE
Price = MAX( Price );

thanks to all

[LifeinAsia]

What do you mean by "illegal?" I don't know anyone who will issue a fine for that. :)

As far as improper syntax goes, you may need to rewrite it this way:
SELECT `Make` , `Model` , `Price`
FROM `inventory`
WHERE Price = (SELECT MAX(Price) FROM `inventory`);

[wel51x]

Thanks.

you do actually get a $250 fine in Singapore; fortunately it's not as bad as chewing gum ;-)

[LifeinAsia]

That's why I don't write code in Singapore. ;)