- SELECT AND CONSUME
- WITH Modifier
- DISTINCT
- ALL
- NORMALIZE Clause
- TOP Clause
- FROM Clause
- Derived Tables
- WHERE Clause
- Specifying Subqueries in Search Conditions
- Correlated Subqueries
- Scalar Subqueries in SELECT Statements
- GROUP BY Clause
- HAVING Clause
- QUALIFY Clause
- SAMPLE Clause
- SAMPLEID Expression
- EXPAND ON Clause
- ORDER BY Clause
- WITH Clause
- SELECT ... INTO
- SQL operators and functions in SQL Date and Time Functions and Expressions.
- JSON data types and methods in JSON Data Type