- - -

- (minus)

- * -

* (multiply)

- / -

/ (divide)

- | -

|| (concatenation function)

- + -

+ (plus)

IconArithmetic list
IconConcatenation using plus (+)

- A -

aggregate functions

IconGROUP BY clause
IconHAVING clause
IconAVG function
IconCOUNT function
IconMAX function
IconMIN function
IconSUM function

ALL predicate

ALTER TABLE statement

AND

IconOperators list
IconLogical operators

ANY predicate

arithmetic operators

IconOperators list
IconArithmetic list

averaging values

AVG function

- B -

BETWEEN predicate

boolean values

- C -

calculated columns

calculations

Cartesian join

case conversion

IconLOWER function
IconUPPER function

case-insensitive comparisons

case-insensitive filtering

CAST function

century in dates

changing table structures

clauses

IconClause list
IconFROM clause
IconWHERE clause
IconORDER BY clause
IconGROUP BY clause
IconHAVING clause

column correlation names

IconColumn correlation names
IconColumn correlation names w. spaces

column names

column types

columns

IconColumn correlation names
IconIS NULL predicate

calculated

combined

empty

referencing

combining columns

combining tables

commands

IconStatement list
IconDDL statement overview

comments

comparing against multiple values

IconBETWEEN predicate
IconIN predicate

Comparison predicates

Comparisons and NULLs

concatenation

Concatenation function

IconConcatenation function
IconConcatenation using plus (+)

conditions

IconWHERE clause
IconPredicate list
IconComparison predicates
IconBETWEEN predicate
IconEXISTS predicate
IconIN predicate
IconLIKE predicate
IconIS NULL predicate
IconSOME / ANY / ALL predicates

constraints

conventions

IconConventions
IconTable names
IconColumn names
IconDate formats
IconTime formats
IconBoolean literals
IconTable correlation names
IconColumn correlation names
IconEmbedded comments
IconReserved words
IconUnsupported language

converting data types

correlation names

IconTable correlation names
IconColumn correlation names
IconColumn correlation names w. spaces

COUNT function

counting rows

CREATE INDEX statement

CREATE TABLE statement

IconNative table column names
IconSQL data types
IconCREATE TABLE statement

CREATE VIEW

creating tables

cross-database joins

- D -

data

IconDELETE statement
IconINSERT statement
IconUPDATE statement

adding

deleting

updating

Data manipulation language

data types

IconNative table column names
IconSQL data types

converting

datatypes

native table

SQL

date formats

date operations

DDL statements

IconDDL statement overview
IconCREATE TABLE statement
IconALTER TABLE statement
IconDROP TABLE statement
IconCREATE INDEX statement
IconDROP INDEX statement

defining column types

DELETE statement

deleting characters

deleting indexes

deleting tables

division

IconOperators list
IconArithmetic list

DML statements

IconStatement list
IconSELECT statement
IconDELETE statement
IconINSERT statement
IconUPDATE statement

DROP INDEX statement

DROP TABLE statement

- E -

embedded comments

equi-join

ESCAPE keyword

EXISTS predicate

EXTRACT function

- F -

filtering data

IconWHERE clause
IconHAVING clause
IconPredicate list
IconComparison predicates
IconBETWEEN predicate
IconEXISTS predicate
IconIN predicate
IconLIKE predicate
IconIS NULL predicate
IconSOME / ANY / ALL predicates

Foreign columns in UPDATE

FRACTIONAL_PART

FROM clause

functions

IconFunction list
IconConcatenation function
IconLOWER function
IconUPPER function
IconSUBSTRING function
IconTRIM function
IconCOUNT function
IconMAX function
IconMIN function
IconSUM function
IconCAST function
IconEXTRACT function
IconConcatenation using plus (+)

- G -

GROUP BY clause

GroupByClause

grouping rows

- H -

HAVING clause

heterogeneous join

- I -

IN predicate

indexes

IconCREATE TABLE statement
IconCREATE INDEX statement
IconDROP INDEX statement

effects of

INNER join

INSERT statement

INTEGER_PART

IS NULL predicate

- J -

joins

IconRelational operators list
IconEqui-join
IconINNER join
IconOUTER join
IconCartesian join
IconUNION join
IconHeterogenous join
IconUpdatable queries

- L -

legend

LENGTH

LIKE predicate

local SQL overview

logical operators

IconOperators list
IconLogical operators

LOWER function

lowercase conversion

- M -

MAX function

maximum values

MIN function

minimum values

minus

IconOperators list
IconArithmetic list

modifying table structures

MODULUS

multiply

IconOperators list
IconArithmetic list

- N -

naming conventions

native column types

NOT

IconOperators list
IconLogical operators

NULL in comparisons

- O -

operators

IconOperators list
IconArithmetic list

OR

IconOperators list
IconLogical operators

ORDER BY clause

OUTER join

- P -

Parameter substitutions

partial-string filtering

plus

IconOperators list
IconArithmetic list

predicates

IconPredicate list
IconComparison predicates
IconBETWEEN predicate
IconEXISTS predicate
IconIN predicate
IconLIKE predicate
IconIS NULL predicate
IconSOME / ANY / ALL predicates

primary indexes

IconUpdatable queries
IconCREATE TABLE statement
IconDROP INDEX statement

- Q -

QBE files

queries

multi-table

IconRelational operators list
IconEqui-join
IconINNER join
IconOUTER join
IconCartesian join
IconUNION join
IconHeterogenous join
IconUpdatable queries

- R -

ranges

read-only queries

relational operators

IconRelational operators list
IconEqui-join
IconINNER join
IconOUTER join
IconCartesian join
IconUNION join
IconHeterogenous join
IconUpdatable queries

remarks

reserved words

restrictions

IconReserved words
IconUnsupported language
IconUpdatable queries

retrieving data

ROUND

- S -

secondary columns

secondary indexes

IconUpdatable queries
IconCREATE INDEX statement
IconDROP INDEX statement

SELECT statement

SOME predicate

sorting data

SQL files

statements

IconStatement list
IconDELETE statement
IconINSERT statement
IconUPDATE statement
IconDDL statement overview
IconCREATE TABLE statement
IconALTER TABLE statement
IconDROP TABLE statement
IconCREATE INDEX statement
IconDROP INDEX statement

string concatenation

string functions

IconConcatenation function
IconLOWER function
IconUPPER function
IconSUBSTRING function
IconTRIM function
IconConcatenation using plus (+)

subqueries

IconEXISTS predicate
IconIN predicate
IconSOME / ANY / ALL predicates

SUBSTRING

SUBSTRING function

SUM function

- T -

table column types

table correlation names

IconTable correlation names
IconColumn correlation names w. spaces

tables

IconTable names
IconColumn names
IconTable correlation names
IconFROM clause

creating

IconColumn names
IconCREATE TABLE statement

deleting

modifying

naming

referencing

IconTable names
IconTable correlation names
IconFROM clause

Time formats

totalling column values

TRIM function

- U -

UNION join

Unsupported language

Updatable queries

UPDATE from foreign column(s)

UPDATE multi-col conditions

UPDATE statement

UPPER function

uppercase conversion

- V -

VIEWs

- W -

WebHelp

WHERE clause

- Y -

Y2K