Expression BETWEEN Start AND End

Expression is the name of the column whose values you want to examine.

Start is the starting value of the range to consider

End is the highest value to consider in the range.

After this condition is executed, it produces the list of values between Start and End. Here is an example:

SELECT Videos.Title, Videos.Director, Videos.CopyrightYear, Videos.Rating
FROM Videos
WHERE (Videos.CopyrightYear) Between 1994 And 2004;

You can use the BETWEEN...AND... expression to create a parameterized query. Here is an example:

BETWEEN [Enter a starting year] AND [Enter an ending year]