AgileApps Support Wiki Pre Release

SQL Syntax

From AgileApps Support Wiki
Revision as of 18:54, 11 November 2011 by imported>Aeric

Here is the syntax for the SQL SELECT statements that the SQL parser recognizes.

Considerations
  • SQL syntax is case insensitive.
  • Field and table names are case sensitive

Learn more: SQL Functions

SELECT STATEMENT

SELECT
[DISTINCT]

Keywords

DISTINCT
Eliminates duplicate rows from the result set.