SELECT [ALL | DISTINCT] [TOP nExpr [PERCENT]]
[Alias.] Select_Item [Column_Name]
[, [Alias.] Select_Item [Column_Name] ...]
FROM [FORCE]
[DatabaseName!]Table [ Local_Alias]
[[INNER | LEFT [OUTER] | RIGHT [OUTER] | FULL [OUTER] JOIN
DatabaseName!]Table [ Local_Alias]
[ON JoinCondition …]
[[INTO Destination]
| [TO FILE FileName [ADDITIVE] | TO PRINTER [PROMPT]
| TO SCREEN]]
[PREFERENCE PreferenceName]
[NOCONSOLE]
[PLAIN]
[NOWAIT]
[WHERE JoinCondition [AND JoinCondition ...]
[AND | OR FilterCondition [AND | OR FilterCondition ...]]]
[GROUP BY GroupColumn [, GroupColumn ...]]
[HAVING FilterCondition]
[UNION [ALL] SELECTCommand]
[ORDER BY Order_Item [ASC | DESC] [, Order_Item [ASC | DESC] ...]]
Exemple
In formularea unei interogari SELECT se pot utiliza:
• * in clauza SELECT pentru a selecta
toate coloanele.
• operatorii de calcul: +,-.*, / (Exemplu)
• functiile de agregare AVG(), COUNT(),
MAX(), MIN(), SUM(), STDDEV(), VARIANCE()
• operatorul IS ( IS NULL or IS
NOT NULL) Exemplu
• operatorul IN pentru a testa apartenenta
unei valori la o multime de valori Exemplu
• operatorul BETWEEN
BETWEEN 6 and 10,
NOT
BETWEEN 6 AND 10, BETWEEN 'A' AND 'C' Exemplu
• operatoryl LIKE pentru verificarea
corespondentei sirurilor de caractere
nume_camp LIKE 'Mo%'
or LIKE '_ _ S%', LIKE '%S%S'
"_" reprezinta un carater,
" %" reprezinta orice numar de caractere. Exemplu