Comanda SELECT

Formatul general al unei fraze (interogari) SELECT este:
SELECT camp1, camp2, … -- Lista de campuri (coloane)
FROM tabel1, tabel2, … -- Lista de tabele
WHERE conditie -- conditie de filtrare a randurilor (inregistrarilor) sau de  legatura intre tabele

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