SQL Reference
- SQL Reference Introduction
- Data Types
- Lexical Structure
- Operators
- SQL Functions
- About SQL Function Examples
- Math and Trig
- Data Type Conversion
- Date/Time Functions and Arithmetic
- String Manipulation
- Aggregate and Aggregate Statistical
- Functions for Handling Nulls
- SQL Window Functions
- SQL Window Functions Introduction
- Aggregate Window Functions
- Ranking Window Functions
- Value Window Functions
- SQL Window Functions Examples
- Nested Data Functions
- Query Directory Functions
- SQL Commands
- Supported SQL Commands
- SET
- RESET
- ALTER SYSTEM
- CREATE TABLE AS (CTAS)
- PARTITION BY Clause
- CREATE VIEW
- DESCRIBE
- DROP TABLE
- DROP VIEW
- EXPLAIN
- SELECT
- SELECT List
- FROM Clause
- GROUP BY Clause
- HAVING Clause
- LIMIT Clause
- OFFSET Clause
- ORDER BY Clause
- UNION Set Operator
- WHERE Clause
- WITH Clause
- SHOW DATABASES and SHOW SCHEMAS
- SHOW FILES
- SHOW TABLES
- USE
- SQL Conditional Expressions
- Reserved Keywords
- SQL Extensions