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
|
6829 Discussions
|
Please Login in order to post a comment
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 DESC LIMIT 1;
MYSQL
SELECT CITY, CHARACTER_LENGTH(CITY) AS LengthOfName FROM STATION ORDER BY LENGTH(CITY) ASC, CITY ASC LIMIT 1; SELECT CITY, CHARACTER_LENGTH(CITY) AS LengthOfName FROM STATION ORDER BY LENGTH(CITY) DESC, CITY DESC LIMIT 1
MySql
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;