You are viewing a single comment's thread. Return to all comments →
select city , length(city) from station order by length(city) desc , city desc limit 1;
select city , length(city) from station order by length(city) asc , city asc limit 1;
in the first one ,
-> city asc limit 1; should be there
I am also confused about that. we should limit answer to 1 and how can we sort it by alphabetic
Its by default.
why we can't just use limit why we are using city limit 1???
same question here also if we dont use city limit it wont give answer
What is the use of limit?