You are viewing a single comment's thread. Return to all comments →
Hi, I'm wondering - why does WHERE LENGTH(CITY) = MAX(LENGTH(CITY)) not work? I get a "Invalid use of group function" error.
Double check that you're not using Oracle, but that you're using MySQL
That's because you need to use 'having' when you use a group function like max or length
Weather Observation Station 5
You are viewing a single comment's thread. Return to all comments →
Hi, I'm wondering - why does WHERE LENGTH(CITY) = MAX(LENGTH(CITY)) not work? I get a "Invalid use of group function" error.
Double check that you're not using Oracle, but that you're using MySQL
That's because you need to use 'having' when you use a group function like max or length