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
|
7211 Discussions
|
Please Login in order to post a comment
(SELECT CITY, LENGTH(CITY) FROM STATION WHERE LENGTH(CITY) = (SELECT MIN(LENGTH(CITY)) FROM STATION) ORDER BY CITY ASC LIMIT 1) UNION (SELECT CITY, LENGTH(CITY) FROM STATION WHERE LENGTH(CITY) = (SELECT MAX(LENGTH(CITY)) FROM STATION) ORDER BY CITY ASC LIMIT 1);
I set Limit = 1, because in problem they just ask the fist row only.
**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; **
We can Either use 2 different Queries or union both queries as everyone did.
according to these question we are write query but return a wrong answer SELECT CITY , LENGTH(CITY) AS NAME_LENGTH FROM STATION ORDER BY LENGTH(CITY) ASC, CITY ASC LIMIT 1 ) UNION ( SELECT CITY , LENGTH(CITY) AS NAME_LENGTH FROM STATION ORDER BY LENGTH(CITY) DESC, CITY ASC LIMIT 1 );
SELECT s.CITY, LENGTH(s.CITY) FROM ( SELECT CITY FROM STATION ORDER BY LENGTH(CITY), CITY FETCH FIRST 1 ROW ONLY) s UNION ALL SELECT l.CITY, LENGTH(l.CITY) FROM ( SELECT CITY FROM STATION ORDER BY LENGTH(CITY) DESC, CITY FETCH FIRST 1 ROW ONLY) l;