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.
This is what I did in MS SQL SERVER ;WITH CTE AS (SELECT CITY, LEN(CITY) LENGHT, ROW_NUMBER() OVER(ORDER BY LEN(CITY), CITY) FLAG FROM STATION ) SELECT CITY, LENGHT FROM CTE WHERE FLAG IN ((SELECT MIN(FLAG) FROM CTE), (SELECT MAX(FLAG) FROM CTE));
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 5
You are viewing a single comment's thread. Return to all comments →
This is what I did in MS SQL SERVER ;WITH CTE AS (SELECT CITY, LEN(CITY) LENGHT, ROW_NUMBER() OVER(ORDER BY LEN(CITY), CITY) FLAG FROM STATION ) SELECT CITY, LENGHT FROM CTE WHERE FLAG IN ((SELECT MIN(FLAG) FROM CTE), (SELECT MAX(FLAG) FROM CTE));