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.
this will work because we are not ordering the elements by their length we are doing it by the aplhabetical order so it does it.....and in the first query the result obtained will be having some set so we must pick out the top one...cool...
select top 1 city,len(city) as shortest from station order by len(city),city
select top 1 city,len(city) as longest from station order by len(city) desc, city
You dont have to "city desc" the second query because they want to display the city alphabetically.
Weather Observation Station 5
You are viewing a single comment's thread. Return to all comments →
for SQL Server:
this will work because we are not ordering the elements by their length we are doing it by the aplhabetical order so it does it.....and in the first query the result obtained will be having some set so we must pick out the top one...cool...
Thank you.....worked for me!!
select top 1 city,len(city) as shortest from station order by len(city),city select top 1 city,len(city) as longest from station order by len(city) desc, city
You dont have to "city desc" the second query because they want to display the city alphabetically.
He ordered DESC in the second query to get the maximum length. By ordering it ASC in the forst query, he got the city with the minimum length.