Weather Observation Station 5

  • + 1 comment

    -- another way for oracle:

    select t1.* from (select City, length(City) from station order by length(city) desc, city) t1 where rownum <= 1 union select t2.* from (select City, length(City) from station order by length(city) , city) t2 where rownum <= 1;