How to Use Between in SQL

Tutorials Shared by the Internet Community

Advertisements


Synopsis

If you need to find the range in some data, then you need to use between as your operator.

Statistics

  • Total Hits - 16258

  • 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

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


Site  |   Broken  |   Tweet  |   Facebook  |     |   Save  |   Liked  |   Down

Advertisements