Clauses
- SELECT specifies desired columns
- FROM specifies relevant tables
- WHERE specifies qualifying conditions for rows
- ORDER BY specifies sorting columns for results
- GROUP BY, HAVING specifies aggregation and statistics
Operators and functions
- arithmetic operators, e.g. +, -, ...
- comparison operators, e.g. =, <, >, BETWEEN, LIKE ...
- logical operators, e.g. AND, OR, NOT, EXISTS,
- set operators, e.g. UNION, IN, ALL, ANY, ...
- statistical functions, e.g. SUM, COUNT, ...
- many other operators on strings, date, currency, ...
|
Última modificación: Thursday, 17 de November de 2005, 17:01