SQL BETWEEN Operator - Mostlikers

18 July, 2014

SQL BETWEEN Operator

Sql Between operator find the database in between two database values. this operator used between and not between data filtering database.


SELECT * FROM tablename WHERE cost BETWEEN 200 AND 300



Sample code

SELECT * FROM tablename WHERE cost BETWEEN 200 AND 300 
 SELECT * FROM tablename WHERE Date BETWEEN #02/02/2014# AND #07/07/2014#

No comments:

Post a comment