Weather Observation Station 5

  • + 3 comments

    for SQL Server:

    select top 1 city, len(city) from station order by len(city), city;
    select top 1 city, len(city) from station order by len(city) desc, city desc;