SQL Manual

• Data Types
  • Data Types
  • Array Types
    • Declaration of array types
    • Array value input
    • Accessing Arrays
• Function
  • Mathematcial Functions
  • Trigonometric Functions
  • String Functions and Operators
  • Other Postgres String Functions
  • Pattern Matching
  • Date/Time Formating Functions
  • Conditional Expressions
  • Array Functions
  • General-Purpose Aggregate Functions
  • Ordered-Set Aggregate Functions
  • Window Functions
  • Subquery Expressions
  • Row and Array Comparisons
  • Set Returning functions
  • Session Information Functions
  • Access Privilege Inquiry Functions
  • Public API Functions
• Extension Functions via Public API
  • Public API Functins Overview
  • APPROX_COUNT_DISTINCT
    • Introduction
    • Synopsis
    • Parameters
    • Example
  • HG_CREATE_TABLE_LIKE
    • Introduction
    • Synopsis
    • Parameters
    • Example
  • HG_SHARD_ID_FOR_DISTRIBUTION_KEY
    • Introduction
    • Synopsis
    • Parameters
    • Example
  • HG_UPDATE_DATABASE_PROPERTY
    • Introduction
    • Synopsis
    • Parameters
    • Limitation
    • Example
  • GET_JSON_OBJECT
    • Introduction
    • Synopsis
    • Parameters
    • Example
  • SET_TABLE_PROPERTY
    • Introduction
    • Synopsis
    • Parameters
    • Example
• DDL
  • Database
    • CREATE DATABASE
      • Introduction
      • Synopsis
      • Parameters
      • Example
    • ALTER DATABASE
      • Introduction
      • Synopsis
      • Parameters
      • Example
    • DROP DATABASE
      • Introduction
      • Synopsis
      • Limitation
      • Example
  • Schema
    • CREATE SCHEMA
      • Public Schema
      • Create Schema
      • Create tables across Schema
    • ALTER SCHEMA
      • Introduction
      • Synopsis
      • Limitation
      • Example
  • Table
    • CREATE TABLE
      • Create Table
        • Synopsis
        • Parameters
        • Limitation
        • Example
      • Set table properties
      • Synopsis
        • Parameters
          • orientation
          • clustering_key
          • segment_key
          • bitmap_columns
          • dictionary_encoding_columns
          • time_to_live_in_seconds
          • distribution_key
      • Add comments
    • CREATE TABLE LIKE
      • Regular Table
        • Introduction
        • Parameters
        • Examples
      • Partition Table
        • Introduction
        • Parameters
        • Example
      • Set Table Property
        • Limitation
    • ALETER TABLE
      • Rename Table
        • Synopsis
        • Example
      • Add Column
        • Synopsis
        • Example
      • Alter Table Property
        • Example
    • DROP TABLE
      • Introduction
      • Synopsis
      • Parameters
      • Example
  • Partition table
    • CREATE/DROP PARTITION TABLE
      • create partition table
        • Introduction
        • Synopsis
        • Limitation
        • Example
      • drop partition table
    • ALTER PARTITON TABLE
      • Introduction
      • Synopsis
      • Parameters
      • Example
  • CAST
    • CREATE CAST
      • Introduction
      • Synopsis
      • Parameters
      • Example
    • DROP CAST
      • Introduction
      • Synopsis
      • Parameters
      • Example
• DML & DQL
  • Insert
    • Introduction
    • Synopsis
    • Parameters
    • Examples
  • Select
    • Introduction
    • Synopsis
    • Description
    • Parameters
      • WITH List
      • SELECT List
      • FROM Clause
      • WHERE Clause
      • GROUP BY Clause
      • DISTINCT Clause
      • COUNT DISTINCT Clause
      • UNION Clause
      • INTERSECT Clause
      • EXCEPT Clause
      • ORDER BY Clause
      • LIMIT Clause
    • Examples
  • Update
    • Introduction
    • Synopsis
    • Parameters
    • Examples
    • Limitations
  • Delete
    • Introduction
    • Synopsis
    • Parameters
    • Examples
• other
  • UNNEST
    • Introduction
    • Synopsis
    • Examples
  • CANCEL QUERY
    • Introduction
    • Synopsis
    • Examples
  • Other SQL Commands