1. Learn
    2. /
  2. Courses
    3. /
  3. Improving Query Performance in SQL Server

Exercise

UNION and UNION ALL

You want a query that returns all cities listed in the Earthquakes database. It should be an easy query on the Cities table. However, to be sure you get all cities in the database you will append the query to the Nations table to include capital cities as well. You will use UNION to remove any duplicate rows.

Out of curiosity, you want to know if there were any duplicate rows. If you do the same query but append with UNION ALL instead, and compare the number of rows returned in each query, UNION ALL will return more rows if there are duplicates.

Instructions 1/3

undefined XP
    1
    2
    3
  • Add the city column from the Cities table to the first query.
  • Append queries using UNION
  • Add the column for the Nation capital to the second query.
  • Check how many rows were returned.