Between

Between:-we use between for providing range .we pass two values which separated by "and"
so we search the value or retrieve the value in specific range.

the table on which we perform between operation
                                                 
                                                           
Ex:-here we supply the range for the age i.e. 20 and 40 which display the result who have the age limit between 20 and 40.it does not display the age 50 row because it does not come in the range.