Weather Observation Station 5

Sort by

recency

|

6829 Discussions

|

  • + 0 comments
    select city, length(city)
    from station
    order by length(city) desc, city asc limit 1;
    
    select city, length(city)
    from station
    order by length(city) asc, city asc limit 1;
    
  • + 0 comments

    SELECT city,LENGTH(CITY) FROM station order by LENGTH (CITY)Asc, CITY ASC LIMIT 1;

    SELECT city,LENGTH(CITY) FROM station order by LENGTH (CITY)desc, CITY DESC LIMIT 1;

  • + 0 comments
    WITH CITY_LENGTH_1 AS (
        SELECT MIN(CITY) AS city,
        LEN(CITY) AS city_length
        FROM STATION
        GROUP BY LEN(CITY)
    )
    SELECT city,
        city_length
    FROM CITY_LENGTH_1
    WHERE city_length IN (SELECT MIN(city_length) FROM CITY_LENGTH_1)
        OR city_length IN (SELECT MAX(city_length) FROM CITY_LENGTH_1)
    ORDER BY city_length 
    
  • + 1 comment

    MYSQL

    SELECT CITY, CHARACTER_LENGTH(CITY) AS LengthOfName FROM STATION ORDER BY LENGTH(CITY) ASC, CITY ASC LIMIT 1; SELECT CITY, CHARACTER_LENGTH(CITY) AS LengthOfName FROM STATION ORDER BY LENGTH(CITY) DESC, CITY DESC LIMIT 1

  • + 0 comments

    MySql

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