Get startedGet started for free

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

View Course

Exercise instructions

  • Select the description and event_year columns.
  • Return rows WHERE the description 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
___ 
  ___ = '___';
Edit and Run Code