CHARACTER
CHARACTER(n)
VARCHAR(n)

BIT
BIT VARYING(n)

INTEGER
SMALLINT
NUMERIC(p, q)
NUMERIC(p)
DECIMAL(p, q)
DECIMAL(p)

FLOAT(p)
FLOAT
REAL
DOUBLE PRECISION

DATE
TIME
TIMESTAMP

CAST(espressione as tipo)

Confronto

<, <=, >, >=, =, <>, like

Appartenenza

operando beetween op1 and op2

[not] in (elenco)

[not] exists(tabella)

espressione is [not] null

create table tabella_base
(
  colonna (tipo, dominio) [not null],
  ...
  primary key (lista_colonne) unique (lista_colonne)
  foreign key (lista_colonne) references tabella_base
  check (condizione)
)

create view tabella_vista as query

drop view tabella_vista

drop table tabella_base

select ... into tabella
...

alter table (tabella_base) add nome_colonna tipo

alter table (tabella_base) drop nome_colonna

insert into tabella_base values (...)

insert into tabella_base select ...

select [ distinct ] espr1, espr2, ..., esprk
from tab1, tab2, ..., tabn

select ...
from ...
where espressione

...

...

...

select ...
...
order by campo1 [asc/desc], ...

Funzioni di aggregazione

count, min, max, sum, avg

Raggruppamenti

select ...
from ...
group by campo1, ..., campon
[having espressione]

Annidamenti di select

...

select ...
from TABELLA as A, TABELLA as B
...