Where
You won't usually want to retrieve every row in your database. You'll have specific information you need in order to answer questions from your boss or colleagues.
The WHERE clause is essential for selecting, updating (and deleting!) data from your tables. You'll continue working with the grid dataset for this exercise.
Bu egzersiz
Introduction to SQL Server
kursunun bir parçasıdırEgzersiz talimatları
- Select the
descriptionandevent_yearcolumns. - Return rows
WHEREthedescriptionis'Vandalism'.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Select description and event_year
SELECT
___,
___
FROM
grid
-- Filter the results
___
___ = '___';