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

Legend

• [ ... ] - Optional (one or none)
• [ ... ]* - Zero or more
• { ... | ... } - Choose one

SELECT STATEMENT

In a select statement, you designate one more columns, separated by commas (or "*" for all columns), a table to get the data from, and additional options:

SELECT

[ DISTINCT ]

{ * | column_expr [, column_expr]* }

FROM table_reference

[WHERE where_clause]

[GROUP BY group_clause]

[ORDER BY order_clause]

[LIMIT limit_clause]

where:

DISTINCT

Eliminates duplicate rows from the result set.

Note:

For example: DISTINCT(customer_name,address)

Learn more:: MySQL Select Statement syntax

column_expr

There are several ways to specify columns:

{ column_name | SQL Function }

[ [AS] alias]

where:

alias

Displayed as the column name in the result set, in the SQL Browser. Can also be used as a field name in a group_expr or order_expr.

For example:

<syntaxhighlight lang="sql" enclose="div">

SELECT CONCAT(last_name,', ',first_name) AS full_name

 FROM Customer_Contacts ORDER BY full_name;

</syntaxhighlight>