SQL Reference
- SQL Reference Introduction
- Data Types
- Lexical Structure
- Operators
- SQL Functions
- About SQL Function Examples
- Math and Trig
- Statistical
- Data Type Conversion
- Data Type Functions
- Date/Time Functions and Arithmetic
- String Manipulation
- Aggregate and Aggregate Statistical
- Functions for Handling Nulls
- Phonetic Functions
- String Distance Functions
- Cryptography Functions
- SQL dialect compatibility functions
- GIS functions
- Time Series Analysis Functions
- IP Networking functions
- 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
- ANALYZE TABLE REFRESH METADATA
- ANALYZE TABLE COMPUTE STATISTICS
- SET
- REFRESH TABLE METADATA
- RESET
- ALTER SYSTEM
- CREATE OR REPLACE SCHEMA
- CREATE TABLE AS (CTAS)
- CREATE TEMPORARY TABLE AS (CTTAS)
- CREATE FUNCTION USING JAR
- PARTITION BY Clause
- CREATE VIEW
- DESCRIBE
- DROP FUNCTION USING JAR
- DROP TABLE
- DROP VIEW
- EXPLAIN
- LATERAL Join
- SELECT
- SELECT List
- FROM Clause
- GROUP BY Clause
- HAVING Clause
- LIMIT Clause
- OFFSET Clause
- ORDER BY Clause
- Set Operators
- WHERE Clause
- WITH Clause
- SHOW DATABASES and SHOW SCHEMAS
- SHOW FILES
- SHOW TABLES
- USE
- Pivot Operators
- SQL Conditional Expressions
- Reserved Keywords
- SQL Extensions