NULLIF

UNPIVOT operator

PIVOT and UNPIVOT Operators

The sorting and NULL values

Getting summarizing values

CASE statement

SELECT statement