SELECT CITY, LENGTH(CITY)

FROM (SELECT CITY, LENGTH(CITY) AS LENG

FROM STATION

ORDER BY LENG, CITY)

WHERE ROWNUM <= 1

SELECT CITY, LENGTH(CITY)

FROM (SELECT CITY, LENGTH(CITY) AS LENG

FROM STATION

ORDER BY LENG DESC, CITY)

WHERE ROWNUM <= 1;

SELECT CITY, LENGTH(CITY)

FROM (SELECT CITY,

ROW_NUMBER() OVER(ORDER BY LENGTH(CITY), CITY) AS RN,

COUNT(*) OVER() AS CNT

FROM STATION)

WHERE RN IN (1, CNT);