SQL Between Operator

The between operator use to  select values (numbers, text or dates ) between  given range.


Syntax -

Select * from table_name where column_name between value1 and value2;

OR

  • Select * from table_name where column_name  <= data (highest data) && column_name >= data (lowest data) ;


sql between operator


Not between

The not between use to  select values (numbers, text or dates ) from outside the given range .

sql not between operator