An SQL primer

• Some other predicates:

  • col1 BETWEEN value1 AND value2
    • Note: BETWEEN is inclusive
  • col1 NOT BETWEEN value1 AND value2
    • Note: NOT BETWEEN is exclusive
  • col1 IN (value1, value2, ..., valuen)
  • col1 NOT IN (value1, value2, ..., valuen)

Vorherige Folie

Nächste Folie

Zurück zur ersten Folie

Graphik-Version anzeigen