• 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