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
|
6326 Discussions
|
Please Login in order to post a comment
**MS SQL **
SELECT TOP 1 CITY,LEN(CITY) FROM STATION WHERE LEN(CITY) = (SELECT MIN(LEN(CITY)) FROM STATION) ORDER BY CITY ASC;
SELECT TOP 1 CITY,LEN(CITY) FROM STATION WHERE LEN(CITY) = (SELECT MAX(LEN(CITY)) FROM STATION) ORDER BY CITY ASC;
SELECT CITY,LENGTH(CITY) FROM STATION WHERE LENGTH(CITY) = (SELECT MIN(LENGTH(CITY)) FROM STATION) ORDER BY CITY ASC LIMIT 1;
SELECT CITY,LENGTH(CITY) FROM STATION WHERE LENGTH(CITY) = (SELECT MAX(LENGTH(CITY)) FROM STATION) ORDER BY CITY ASC LIMIT 1;
SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) ASC, CITY ASC LIMIT 1; SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC, CITY ASC LIMIT 1;
(SELECT CITY,LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) ASC,CITY ASC LIMIT 1) UNION (SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC,CITY ASC LIMIT 1) ;