How to Use Between in SQL
Tutorials Shared by the Internet Community
Total Hits - 27402
Total Votes - 102 votes
Vote Up - 44 votes
Vote Down - 58 votes
Domain - www.sqltutorials.net
Category - Basic SQL/Basic SQL Misc
Submitted By - Shekhar
Submitted on - 2008-04-11 10:13:33
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; ...