How To Use Between Operator...?

Select Col_name
From Table_name
Where Col_name
Between val1 And val2
e.g
Select * from Technology where id Between 2 and 3