Difference between revisions of "SQL Syntax"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
| Line 9: | Line 9: | ||
;Legend: | ;Legend: | ||
:* [ ... ] - Optional | :* [ ... ] - Optional | ||
:* [ ... ]* - Zero or more | |||
:* { ... | ... } - Choose one | :* { ... | ... } - Choose one | ||
| Line 14: | Line 15: | ||
In a ''select'' statement, you designate one more columns, separated by commas, or you specify "*" for all columns, as well as a table to get the data from, and additional options: | In a ''select'' statement, you designate one more columns, separated by commas, or you specify "*" for all columns, as well as a table to get the data from, and additional options: | ||
:SELECT | :SELECT | ||
::{ * | [[#column_expr|column_expr]] | ::{ * | [[#column_expr|column_expr]] [, [[#column_expr|column_expr]]]* } | ||
::FROM [[#table_reference|table_reference]] | ::FROM [[#table_reference|table_reference]] | ||
:::[WHERE where_clause] | :::[WHERE where_clause] | ||
Revision as of 19:26, 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
- [ ... ]* - Zero or more
- { ... | ... } - Choose one
SELECT STATEMENT
In a select statement, you designate one more columns, separated by commas, or you specify "*" for all columns, as well as a table to get the data from, and additional options:
- SELECT
- { * | column_expr [, column_expr]* }
- FROM table_reference
- [WHERE where_clause]
- [GROUP BY group_clause]
- [ORDER BY order_clause]
- [LIMIT limit_clause]
column_expr
There are several ways to specify columns:
- { column_name
- | [DISTINCT] column_name
- | [DISTINCT](column_name)
- ...
- }
where:
- DISTINCT
- Eliminates duplicate rows from the result set.