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.
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
;
Cookie support is required to access HackerRank
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 →
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 ;