Excluding out of range values
In the previous exercise, you detected the rows with a number of ratings that were out of range.
The logical operator BETWEEN, and the comparison operators >, <, and =, can help you to exclude the rows with out of range values.
This time, you want to get all the rows from the series table, ranging from 0 to 5000.
Bu egzersiz
Cleaning Data in SQL Server Databases
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
SELECT * FROM series
-- Exclude the out of range values
WHERE ___ ___ 0 ___ 5000