How to Use Between in SQL

Tutorials Shared by the Internet Community


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.


  • Total Hits - 33519

  • Total Votes - 103 votes

  • Vote Up - 45 votes

  • Vote Down - 58 votes

  • Domain -

  • 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;    More detail...

Broken  |   Save  |   Liked  |   Down

E-Books Store