SQL Syntax

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

column_expr (column_expr)*

[FROM table_references

[WHERE where_clause]

[GROUP BY group_clause]

[ORDER BY order_clause]

[LIMIT limit_clause]

column_expr

column_name

| [DISTINCT] column_name

| [DISTINCT](column_name)

...

where:

DISTINCT

Eliminates duplicate rows from the result set.