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.
  1. Prepare
  2. SQL
  3. Basic Select
  4. Weather Observation Station 5
  5. Discussions

Weather Observation Station 5

  • crzoppi
     + 1 comment

    I tried a bunch of different things but for some reason I couldn't get them to work. And writing two different queries was giving me the right results but column headers in the middle for some reason. I ended up creating at temp table and inserting into that. Perhaps not the most elegant or efficient solution, but solved it for TSQL, lol.

    Create table #temp(
City varchar (21),
Length int
);

Insert INTO #temp
Select Top 1 City, LEN(City) as Length
FROM Station Order By Length desc, City asc;

Insert INTO #temp
Select Top 1 City, LEN(City) as Length
FROM Station Order By Length asc, City asc;

Select * from #temp;