Difference between IN and BETWEEN, that are used inside a WHERE clause

   The BETWEEN clause is used to fetch a range of values, whereas the IN clause fetches data from a list of specified values.