Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases SQL Basics Finding the Data You Want Searching Within a Range of Values

Posted by Iain Simmons
Iain Simmons
Treehouse Moderator 32,305 Points

BETWEEN is inclusive

Not specifically a question, but just something I noted while watching this video: the BETWEEN keyword is inclusive of the values. That is, we should think of it replacing the greater-than-or-equal-to >= and less-than-or-equal-to <=

2 Answers

Steven Parker
Steven Parker
231,236 Points
Steven Parker
Steven Parker
231,236 Points

Yes, essentially this:

WHERE something BETWEEN x AND y

is shorthand for:

WHERE something >= x AND something <= y

Not what you'd expect if you consider the word between literally! But I think SQL may have been created to appease accountants and not programmers. :wink:

Nathan Tallack
Nathan Tallack
22,160 Points
Nathan Tallack
Nathan Tallack
22,160 Points

A little counter intuative. Especially to a programming mindset. You would not expect between to default to inclusive.

Good to know though. Thanks for that. :)

Ryan Hartigan
Ryan Hartigan
3,425 Points
Ryan Hartigan
Ryan Hartigan
3,425 Points

Is this similar with other systems like Postgres as well?