Difference between revisions of "SQL Syntax"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 31: Line 31:
There are several ways to specify columns:
There are several ways to specify columns:


:{ ''column_name''
:{ ''column_name'' | ''column_name'' AS ''alias'' | ''column_name'' ''alias'' }
:| ''column_name'' AS ''alias''
 
:| ''column_name'' ''alias''
:}
where:
where:
:;''alias'': ???
:;''alias'': ???

Revision as of 19:47, 11 November 2011

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)

column_expr

There are several ways to specify columns:

{ column_name | column_name AS alias | column_name alias }

where:

alias
???