You are viewing a single comment's thread. Return to all comments →
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?