Get startedGet started for free

Removing missing values

There are a number of different techniques you can use to fix missing data in T-SQL and in this exercise, you will focus on returning rows with non-missing values. For example, to return all rows with non-missing SHAPE values, you can use:

SELECT *  
FROM Incidents
WHERE Shape IS NOT NULL

This exercise is part of the course

Intermediate SQL Server

View Course

Exercise instructions

Write a T-SQL query which returns only the IncidentDateTime and IncidentState columns where IncidentState is not missing.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Return the specified columns
___
FROM Incidents
-- Exclude all the missing values from IncidentState  
WHERE ___
Edit and Run Code