8.BETWEEN AND NOT EQUAL

 SELECT *

FROM student

WHERE ROLL BETWEEN 2 AND 4;

SELECT *

FROM student

WHERE ROLL!=1;