How to Use Between in SQL
|Top Tutorials||New Tutorials||Submit||Login||Register|
Total Hits: 9810
Total Votes: 135 votes
Category: Basic SQL/Basic SQL Misc
Submitted on: 2008-04-11 10:13:33
Submitted By: Shekhar
Description:We have previously found the minimum and maximum range for a price column in a table.
But what if we wanted to find the values in between? Say for example you wanted to view all the products you sell between $50 and $100 dollars?
SELECT * FROM products WHERE price BETWEEN 50 AND 100; More detail...