- name: Overview

href: queries.md

- name: SELECT

href: select-transact-sql.md

items:

- name: SELECT Clause

href: select-clause-transact-sql.md

- name: SELECT Examples

href: select-examples-transact-sql.md

- name: SELECT - FOR Clause

href: select-for-clause-transact-sql.md

- name: SELECT - GROUP BY

href: select-group-by-transact-sql.md

- name: SELECT - HAVING

href: select-having-transact-sql.md

- name: SELECT - INTO Clause

href: select-into-clause-transact-sql.md

- name: SELECT - ORDER BY Clause

href: select-order-by-clause-transact-sql.md

- name: SELECT - OVER Clause

href: select-over-clause-transact-sql.md

- name: FROM

href: from-transact-sql.md

items:

- name: FROM - Using PIVOT and UNPIVOT

href: from-using-pivot-and-unpivot.md

- name: WHERE

href: where-transact-sql.md

items:

- name: MATCH

href: match-sql-graph.md

- name: Hints

href: hints-transact-sql.md

items:

- name: Hints - Join

href: hints-transact-sql-join.md

- name: Hints - Query

href: hints-transact-sql-query.md

- name: Hints - Table

href: hints-transact-sql-table.md

- name: AT TIME ZONE

href: at-time-zone-transact-sql.md

- name: Aliasing (Azure SQL Data Warehouse, Parallel Data Warehouse)

href: aliasing-azure-sql-data-warehouse-parallel-data-warehouse.md

- name: EXPLAIN

href: explain-transact-sql.md

- name: OPTION Clause

href: option-clause-transact-sql.md

- name: OUTPUT Clause

href: output-clause-transact-sql.md

- name: Predicates

href: predicates.md

items:

- name: CONTAINS

href: contains-transact-sql.md

- name: FREETEXT

href: freetext-transact-sql.md

- name: IS NULL

href: is-null-transact-sql.md

- name: PREDICT

href: predict-transact-sql.md

- name: READTEXT

href: readtext-transact-sql.md

- name: Search Condition

href: search-condition-transact-sql.md

- name: Subqueries (Azure SQL Data Warehouse, Parallel Data Warehouse)

href: subqueries-azure-sql-data-warehouse-parallel-data-warehouse.md

- name: Table Value Constructor

href: table-value-constructor-transact-sql.md

- name: TOP

href: top-transact-sql.md

- name: UPDATE

href: update-transact-sql.md

- name: UPDATETEXT

href: updatetext-transact-sql.md

- name: WITH common_table_expression

href: with-common-table-expression-transact-sql.md

- name: WRITETEXT

href: writetext-transact-sql.md