Shared Tutorials
Tutorials Shared by the Internet Community
Advertisements
| Top Tutorials | New Tutorials | Submit | Login | Register |
Tutorial Basic Detail
How to Use Between in SQL
If you need to find the range in some data, then you need to use between as your operator.http://www.sqltutorials.net/comparison/sqls-between-range.html
Total Hits: 3384
- Average Rating :
Total Votes: 36 votes
Average Rating: 2.5 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;
Rating Detail
| Stars | Percentage | Total Vote |
|---|---|---|
| |
   16.67% |
6 |
| |
   16.67% |
6 |
| |
   16.67% |
6 |
| |
   16.67% |
6 |
| |
   16.67% |
6 |