Get startedGet started for free

CTE syntax

Select all the T-SQL keywords used to create a Common table expression.

  1. DEALLOCATE
  2. OPEN
  3. AS
  4. WITH
  5. CTE

This exercise is part of the course

Intermediate SQL Server

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise