Local SQL

All topic groups 

Local SQL overview

Naming conventions

Operators [Local SQL]

Reserved words

Data definition

Data manipulation

Parameter substitutions in DML statements

Aggregate functions [Local SQL]

String functions [Local SQL]

Date function [Local SQL]

Updateable queries

Restrictions on live queries

Restrictions on live joins

Constraints

Statements supported

ALTER TABLE

CREATE INDEX

CREATE TABLE

Data type mappings for CREATE TABLE

DELETE [Local SQL]

DROP INDEX

DROP TABLE

INSERT [Local SQL]

SELECT [Local SQL]

FROM clause

WHERE clause

ORDER BY clause

GROUP BY clause

HAVING clause

UNION clause

Heterogeneous joins

SAVE TO clause

UPDATE [Local SQL]