You are viewing a single comment's thread. Return to all comments →
-- better and optimised
-- CITIES WITH LENGTH WITH MAX_MIN AS ( SELECT MAX(LENGTH(CITY)) MAX_LEN, MIN(LENGTH(CITY)) MIN_LEN FROM STATION ) SELECT CITY, LEN_CITY FROM ( SELECT CITY, LENGTH(CITY) AS LEN_CITY, ROW_NUMBER() OVER (PARTITION BY LENGTH(CITY) ORDER BY CITY ) RN FROM STATION JOIN MAX_MIN ON LENGTH(CITY) IN (MAX_LEN,MIN_LEN) ) T WHERE RN = 1;
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 →
-- better and optimised