The Between Operator


#1

https://www.codecademy.com/courses/learn-sql-queries/lessons/queries/exercises/between?action=lesson_resume&course_redirect=learn-sql

why is it that…


SELECT * FROM movies
WHERE name BETWEEN 'A' AND 'J';

does not include movies with whose name starts with ‘J’, but…

SELECT * FROM movies 
WHERE year BETWEEN 1990 AND 2000;

includes movies released in the year 2000?


#2

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.