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.
This exercise is part of the course
Introduction to SQL Server
Exercise instructions
- Select the
description
andevent_year
columns. - Return rows
WHERE
thedescription
is'Vandalism'
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Select description and event_year
SELECT
___,
___
FROM
grid
-- Filter the results
___
___ = '___';