Weather Observation Station 5

  • + 36 comments

    Here is Oracle solution from my HackerrankPractice repository:

    SELECT *
    FROM
        (SELECT CITY, LENGTH(CITY)
        FROM STATION
        ORDER BY LENGTH(CITY), CITY)
    WHERE ROWNUM = 1
    UNION
    SELECT *
    FROM
        (SELECT CITY, LENGTH(CITY)
        FROM STATION
        ORDER BY LENGTH(CITY) DESC, CITY)
    WHERE ROWNUM = 1;
    

    Feel free to ask if you have any questions :)