EXCEPT
EXCEPT does the opposite of INTERSECT. It is used to check if data, present in one table, is absent in another.
You want to know which countries have no recorded earthquakes. You can get this information by comparing the Nations table with the Earthquakes table.
Bu egzersiz
Improving Query Performance in SQL Server
kursunun bir parçasıdırEgzersiz talimatları
- Add the country code column from the
Nationstable. - Add the operator that compares the two queries.
- Add the table with country codes to the right query.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
SELECT ___ -- Add the country code column
FROM Nations
___ -- Add the operator to compare the two queries
SELECT Country
FROM ___; -- Table with country codes