You are viewing a single comment's thread. Return to all comments →
select city, length(city) from (select * from station order by length(city) asc, city asc) where rownum = 1;
select city, length(city) from (select * from station order by length(city) desc, city asc) where rownum = 1;
I run it on oracle, so i use 'rownum' instead of 'limit'
Weather Observation Station 5
You are viewing a single comment's thread. Return to all comments →
select city, length(city) from (select * from station order by length(city) asc, city asc) where rownum = 1;
select city, length(city) from (select * from station order by length(city) desc, city asc) where rownum = 1;
I run it on oracle, so i use 'rownum' instead of 'limit'