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.
Weather Observation Station 5
Weather Observation Station 5
Sort by
recency
|
6118 Discussions
|
Please Login in order to post a comment
SELECT city, length (city) FROM station WHERE LENGTH(city) = (SELECT MAX(LENGTH(city)) FROM station) ORDER BY city LIMIT 1;
SELECT city, length (city) FROM station WHERE LENGTH(city) = (SELECT min(LENGTH(city)) FROM station) ORDER BY city LIMIT 1;
SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC, CITY LIMIT 1; SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) ASC, CITY LIMIT 1;
select city, len from ( select city, length(city) as len , rank() over (order by length(city),city) as min_len , rank() over (order by length(city) desc,city) as max_len from station )a where min_len = 1 or max_len = 1
select CITY , length(CITY) from station order by length(city) , CITY LIMIT 1; select CITY , length(CITY) from station order by length(city) DESC , CITY LIMIT 1;
select city, length(city) from (select * from station order by length(city), city ) where rownum=1 union all(select city, length(city) from (select * from station order by length(city) desc, city ) where rownum=1);
Oracle SQL