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.
------------------------oracle----------------------------
select city,length(city) from (select city,rownum as rid from (select city,length(city) from station order by length(city),city))
where rid = 1 or rid = (select max(rownum) from station);
Weather Observation Station 5
You are viewing a single comment's thread. Return to all comments →
------------------------oracle---------------------------- select city,length(city) from (select city,rownum as rid from (select city,length(city) from station order by length(city),city)) where rid = 1 or rid = (select max(rownum) from station);
could you please explain this query ?
Great solution