• Apollo SQL
  • Introduction
  • Features
  • Using Apollo SQL
    • Overview
    • New in Apollo SQL
    • Deployment
    • Inline Table Definitions
    • Reserved Words
    • Data Types
    • Using Cross-tab Queries to Present Summary Data
    • Using TRANSFORM and PIVOT to Create Cross-tab Queries
    • Creating Fixed Column Headers with the IN() Predicate
    • Summary Data Created by the GROUP BY Clause
    • Other SQL References
  • DDL & DML Statements
    • Aliases, AS, and IN
    • ALTER TABLE
    • CREATE INDEX
    • CREATE TABLE
    • DDL and DML
    • DELETE [WHERE]
    • DISTINCT
    • DROP INDEX
    • DROP TABLE
    • GROUP BY [HAVING]
    • INSERT INTO [WHERE] VALUES
    • INTO
    • IS [NOT] NULL
    • JOIN
    • LIKE
    • MERGE
    • ORDER BY
    • SELECT
    • Subqueries (or Subselects)
    • TRANSFORM. . . PIVOT
    • UPDATE  [SET] [WHERE]
    • WHERE
  • Aggregate Functions
    • Overview
    • AVG
    • COUNT
    • MAX
    • MIN
    • SUM
  • Arithmetic Functions
    • Overview
    • Abs
    • ArcTan
    • Cos
    • Exp
    • Frac
    • Int
    • Ln
    • MINOF
    • MAXOF
    • Pi
    • Power
    • Round
    • RoundDec
    • Sin
    • Sqr
    • Sqrt
    • STDEV
    • Trunc
    • TruncDec
  • Conditional Functions
    • Overview
    • IF
  • Date and Time Functions
    • Overview
    • DAY
    • HOUR
    • MIN (Date and Time)
    • MONTH
    • MSEC
    • Now
    • SEC
    • YEAR
  • String Functions
    • Overview
    • Copy
    • Extract
    • Format
    • FormatDateTime
    • FormatFloat
    • Left
    • Length
    • Lower
    • Pos
    • Right
    • SubString
    • Trim
    • Upper