You are viewing a single comment's thread. Return to all comments →
SELECT city, length_of_city FROM ( SELECT TOP 1 city, LEN(city) AS length_of_city FROM station ORDER BY LEN(city) ASC, city ASC ) AS MinCity
UNION ALL
SELECT city, length_of_city FROM ( SELECT TOP 1 city, LEN(city) AS length_of_city FROM station ORDER BY LEN(city) DESC, city ASC ) AS MaxCity;
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 5
You are viewing a single comment's thread. Return to all comments →
SELECT city, length_of_city FROM ( SELECT TOP 1 city, LEN(city) AS length_of_city FROM station ORDER BY LEN(city) ASC, city ASC ) AS MinCity
UNION ALL
SELECT city, length_of_city FROM ( SELECT TOP 1 city, LEN(city) AS length_of_city FROM station ORDER BY LEN(city) DESC, city ASC ) AS MaxCity;