Weather Observation Station 5

  • + 2 comments

    select * from (select city , length(city) from station order by length(city) desc, city desc) where rownum = 1 union select * from (select city , length(city) from station order by length(city) asc, city asc) where rownum = 1;