StationX
Start free

Browse › T-SQL Database Query

Filter Data in Transact-SQL

Guided

Part of T-SQL Database Query Topic: Data Science

Access

StationX Infrastructure Labs — 3 attempts per lab

🔒 Add StationX Infrastructure Labs — $149 / year · 3 attempts per lab

Already have access? Sign in.

New to this? Try a free practice lab — a scripted hacking challenge in your browser, no account needed.

What you'll do

In this challenge, you will write several Transact-SQL queries by using filtering.

  1. Launch Microsoft SQL Server Management Studio
  2. Develop queries that return filtered data from a table by using the WHERE clause
  3. Develop more specific queries which use the BETWEEN and LIKE logical operators
  4. Explore queries that filter data based on NULL values

Note: Once you begin a challenge you will not be able to pause, save, or return to your progress. Please ensure you have set aside enough time to complete the challenge before you start.

  • ⏱ About 30 minutes