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.
a simple solution:
select small.a,b from
(select city a,length(city) b
from station
order by b, a)small where rownum=1
union
select big.a,b from
(select city a , length(city)b
from station
order by b desc ,a desc)big
where rownum=1;
Weather Observation Station 5
You are viewing a single comment's thread. Return to all comments →
a simple solution: select small.a,b from (select city a,length(city) b from station order by b, a)small where rownum=1 union select big.a,b from (select city a , length(city)b from station order by b desc ,a desc)big where rownum=1;