How to Use Between in SQL

Top Tutorials

New Tutorials

Submit

Login

Register

Tutorial Detail

• Total Hits: 3364

• Average Rating :
  

•  

• Total Votes: 36 votes

• Category: Basic SQL/Basic SQL Misc

• Submitted on: 2008-04-11 10:13:33

• Submitted By: Shekhar

• Set as Favorite

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...

Rating Detail

Stars	Percentage	Total Vote
	16.67%	6
	16.67%	6
	16.67%	6
	16.67%	6
	16.67%	6

Caste Your Vote

Rating	Selection	Guidelines
Poor:		Very disappointing, useless.
Fair:		Below average, disappointing but not useless.
Good:		About average in its class.
Very Good:		Above average for its category.
Excellent:		One of the best Tutorials in its category.

---