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

Exercise

Limit the rows with TOP

Your seismologist friend that is doing a study on earthquakes in South East Asia has asked you to subset a query that you provided her. She wants two additional queries for earthquakes recorded in Indonesia and Papua New Guinea. The first returning the ten shallowest earthquakes and the second the upper quartile of the strongest earthquakes.

Instructions 1/2

undefined XP
    1
    2
  • Limit the number of rows to ten.
  • Order the results from shallowest to deepest.