You are viewing a single comment's thread. Return to all comments →
Code wont work for following city names data:
you code will give:
But we need
For first row sort the table by city length in ascending and the than by city name also in ascending order limiting the output to 1
For second row sort the table by city length in descending and the than by city name in ascending order again limiting the output to 1.
Can't we do this in one single query rather than 2?