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.
  1. Prepare
  2. SQL
  3. Basic Select
  4. Weather Observation Station 5
  5. Discussions

Weather Observation Station 5

Sort by

recency

|

6896 Discussions

|

  • mohatmaislam
     + 0 comments

    MYSQL

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

  • jamer_catalla
     + 0 comments

    -- SHORTEST CITY NAME

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

    -- LONGEST CITY NAME

    SELECT CITY, LENGTH(CITY) AS name_length FROM STATION WHERE LENGTH(CITY) = (SELECT MAX(LENGTH(CITY)) FROM STATION) ORDER BY CITY LIMIT 1;

  • dearr_beccajay
     + 0 comments

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

    SELECT CITY, LENGTH(CITY) AS name_length FROM STATION WHERE LENGTH(CITY) = (SELECT MAX(LENGTH(CITY)) FROM STATION) ORDER BY CITY LIMIT 1;

  • nilawar_shriyash
     + 1 comment

    Can we have more optimized query than below? I'd like to know if we have more optimized solution for this scenario.

    These queries are in MySQL. select city, CHAR_LENGTH(city) as lenghtofcity from station order by CHAR_LENGTH(city) asc,city asc limit 1; select city, CHAR_LENGTH(city) as lenghtofcity from station order by CHAR_LENGTH(city) desc,city desc limit 1;

  • rubandivyaraj
     + 0 comments

    (SELECT CITY, LENGTH(CITY) FROM STATION order by length(city) asc, city asc limit 1) union (SELECT CITY, LENGTH(CITY) FROM STATION order by length(city) desc, city desc limit 1);