tuples. For Example: ( ) To retrieve vouchers with amount ranging between , and , , following query need be formulated. ( Model-I ) Vno, Amount Vouchers Amount BETWEEN AND 10000 ; (Model-II) Vno, Amount Vouchers AS V, Details AS D WHERE . V.vno = D.vno AND Amount BETWEEN , AND , ; VII.
Another feature of SQL permits the use of standard arithmetic operators,