BETWEEN - Between Two Values

Syntax

Description:

    WW BETWEEN W1 AND W2 tells the DBMS , that WW must be between W1 and W2.

    Example:

SELECT vnum,anz,preis
 FROM torder
 WHERE preis BETWEEN 100 AND 500

Here are the fields vnum and preis from the table torder selected, where the field preis have an value between 100 and 500.