Overview SELECT SELECT Clause SELECT Examples SELECT - FOR Clause SELECT - GROUP BY SELECT - HAVING SELECT - INTO Clause SELECT - ORDER BY Clause SELECT - OVER Clause FROM FROM - Using PIVOT and UNPIVOT WHERE MATCH Hints Hints - Join Hints - Query Hints - Table AT TIME ZONE Aliasing (Azure SQL Data Warehouse, Parallel Data Warehouse) EXPLAIN OPTION Clause OUTPUT Clause Predicates CONTAINS FREETEXT IS NULL PREDICT READTEXT Search Condition Subqueries (Azure SQL Data Warehouse, Parallel Data Warehouse) Table Value Constructor TOP UPDATE UPDATETEXT WITH common_table_expression WRITETEXT