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
|
6053 Discussions
|
Please Login in order to post a comment
select CITY,LENGTH(CITY) from STATION order by Length(CITY) asc, CITY limit 1; select CITY,LENGTH(CITY) from STATION order by Length(CITY) desc, CITY limit 1;
mysql solution:
SELECT CITY, CHAR_LENGTH(CITY) FROM STATION WHERE CHAR_LENGTH(CITY) = (SELECT MIN(CHAR_LENGTH(CITY)) FROM STATION) ORDER BY CITY LIMIT 1;
SELECT CITY, CHAR_LENGTH(CITY) FROM STATION WHERE CHAR_LENGTH(CITY) = (SELECT MAX(CHAR_LENGTH(CITY)) FROM STATION) ORDER BY CITY LIMIT 1;
may any one explain to me why my code is wrong as already there are output this is code : SELECT city, LENGTH(city) AS city_length FROM STATION WHERE LENGTH(city) = ( SELECT MIN(LENGTH(city)) FROM STATION) and rownum=1 UNION ALL SELECT city, LENGTH(city) AS city_length FROM STATION WHERE LENGTH(city) = ( SELECT MAX(LENGTH(city)) FROM STATION) and rownum=1 ORDER BY city_length ASC, city ASC ;
My MS SQL Solution. I wonder why LIMIT didnt work.
Select Top 1 CITY, len(CITY) from STATION where len(CITY) = (Select min (len(CITY)) from STATION) order By CITY ;
Select Top 1 CITY, len(CITY) from STATION where len(CITY) = (Select max (len(CITY)) from STATION) order By CITY ;
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; simple code