SQL

Command Window

The key interface for writing queries and scripts.

Query Builder

A tab within the Command Window that facilities writing SQL with greatly reduced keyboarding.

Functions

 

Aggregates

 

SQL Statements

 

SQL Operators

 

SQL Functions

 

Temporary Databases

 

BATCH and THREADS

 

COLLATE

 

COLLECT

 

DISTINCT

 

EXECUTE

 

GROUP BY

 

JOIN Statements

 

ORDER BY

 

PRAGMA

 

SPLIT

 

UNION / EXCEPT / INTERSECT

 

VALUES

 

LIKE Operator

 

Other SQL Clauses

 

Editable Results Tables