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.
ive changed the code and it still works.
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;
we can also write this query in MySql as
select city, length(city) from station order by length(city) limit 1; select city, length(city) from station order by length(city) desc limit 1;
'asc' stands for ascending order.
The query works fine even when 'asc' is removed from the query because the default order for string is alphabetical(first words starting with 'a' then 'b',...) which is exactly what this question demands.
Weather Observation Station 5
You are viewing a single comment's thread. Return to all comments →
ive changed the code and it still works. 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;
why did you put 'asc' limit 1
we can also write this query in MySql as select city, length(city) from station order by length(city) limit 1; select city, length(city) from station order by length(city) desc limit 1;
'asc' stands for ascending order. The query works fine even when 'asc' is removed from the query because the default order for string is alphabetical(first words starting with 'a' then 'b',...) which is exactly what this question demands.