Lazzycoder Code For Everyone

Have a Question?

If you have any question you can ask below or enter what you are looking for!

    BETWEEN

    29-12-2015 17:48:02 MSSQL / Basics 0 Bookmark(s) 195 View(s)

     

    The BETWEENoperator let you select a range of values. The values can be numbers, dates or text.

    
SELECT * FROM Products
WHERE Price BETWEEN 0 AND 150;

SELECT * FROM Customers
WHERE LastName BETWEEN 'C' AND 'M'; 

SELECT * FROM Customers
WHERE DateOfBirth BETWEEN '01/01/1970' AND '01/01/1990';