Tutorials Shared by the Internet Community
|Top Tutorials||New Tutorials||Submit||Login||Register|
Tutorial Basic Detail
Total Hits: 15320
Total Votes: 154 votes
Average Rating: 3.82 out of 5
Category: Basic SQL/Misc
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;