The BETWEEN used to fetch values within a given range.
The BETWEEN provides begin and end values.
Syntax
SELECT column1,column2 FROM tablename WHERE column1 BETWEEN startvalue AND endvalue
Example
SELECT * FROM faculty WHERE faculty_id BETWEEN 1 AND 5
Copyright ©2022 coderraj.com. All Rights Reserved.