clock  Mon - Sun 8.00 AM - 8.00 PM
mail  edu@teknowize.com
fb
instagram
play store
pinterest

More

SQL between operator

Imperial Advance Hero Image

SQL between operator

 

between

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) ;

 

Not between

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

MySql