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.
Can we have more optimized query than below?
I'd like to know if we have more optimized solution for this scenario.
These queries are in MySQL.
select city, CHAR_LENGTH(city) as lenghtofcity from station order by CHAR_LENGTH(city) asc,city asc limit 1;
select city, CHAR_LENGTH(city) as lenghtofcity from station order by CHAR_LENGTH(city) desc,city desc limit 1;
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 →
Can we have more optimized query than below? I'd like to know if we have more optimized solution for this scenario.
These queries are in MySQL. select city, CHAR_LENGTH(city) as lenghtofcity from station order by CHAR_LENGTH(city) asc,city asc limit 1; select city, CHAR_LENGTH(city) as lenghtofcity from station order by CHAR_LENGTH(city) desc,city desc limit 1;