We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Loading...
  1. Practice
  2. SQL
  3. Basic Select
  4. Weather Observation Station 5
  5. Discussions

Weather Observation Station 5

  • lvrosa + 2 comments

    Without use of variables (MySQL):

    SELECT CITY,LENGTH(CITY) FROM STATION WHERE LENGTH(CITY) = (
    SELECT MIN(LENGTH(CITY)) FROM STATION
) ORDER BY CITY LIMIT 1;

SELECT CITY,LENGTH(CITY) FROM STATION WHERE LENGTH(CITY) = (
    SELECT MAX(LENGTH(CITY)) FROM STATION
) ORDER BY CITY LIMIT 1;
    • ssheu + 2 comments

      Hi, I'm wondering - why does WHERE LENGTH(CITY) = MAX(LENGTH(CITY)) not work? I get a "Invalid use of group function" error.

      • mchuong + 0 comments

        Double check that you're not using Oracle, but that you're using MySQL

      • aashiq_baig + 0 comments

        That's because you need to use 'having' when you use a group function like max or length

    • claritywhisk + 1 comment

      SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) ASC,CITY LIMIT 1;

      • Logan_47 + 0 comments

        what the is use of writing city before limit???