Difference between revisions of "SQL Syntax"
From AgileApps Support Wiki
imported>Aeric (Created page with "Here is the syntax for the SQL SELECT statements that the SQL parser recognizes. ''Learn more:'' SQL Functions") |
imported>Aeric |
||
| Line 1: | Line 1: | ||
Here is the syntax for the SQL SELECT statements that the SQL parser recognizes. | 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]] | ''Learn more:'' [[SQL Functions]] | ||
__TOC__ | |||
==SELECT STATEMENT== | |||
:SELECT | |||
::[DISTINCT] | |||
:: | |||
===Keywords=== | |||
:;DISTINCT:Eliminates duplicate rows from the result set. | |||
Revision as of 18:54, 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
SELECT STATEMENT
- SELECT
- [DISTINCT]
Keywords
- DISTINCT
- Eliminates duplicate rows from the result set.