Thus, in this example, d BETWEEN 2005 AND 2000 INCREMENT ???1 designates rows d=2005, 2004, . . . 2000 in that order and d BETWEEN 2005 AND 2000 INCREMENT 1 designates an empty range. [0293] Additionally, the INCREMENT operator applies to all data types for which addition & subtraction is supported, i.e., numeric and date types.