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.
Cet exercice fait partie du cours
Improving Query Performance in SQL Server
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
SELECT ___ ___ -- Limit the number of rows to ten
Latitude,
Longitude,
Magnitude,
Depth,
NearestPop
FROM Earthquakes
WHERE Country = 'PG'
OR Country = 'ID'
___ ___ ___; -- Order results from shallowest to deepest