You are viewing a single comment's thread. Return to all comments →
This is marked "Easy"? This is the convolution that I had to go through with Oracle:
(select * from (select city, length(city) from station where length(city) = (select max(length(city)) from station) order by city asc) where rownum = 1) union (select * from (select city, length(city) from station where length(city) = (select min(length(city)) from station) order by city asc) where rownum = 1);
Weather Observation Station 5
You are viewing a single comment's thread. Return to all comments →
This is marked "Easy"? This is the convolution that I had to go through with Oracle: