Ads

Thursday, 26 September 2013

MySQL BETWEEN Operator

The BETWEEN operator is used to select values within a range.

Syntax
 SELECT columnName  
 FROM tableName  
 WHERE columnName BETWEEN value1 AND value2;  

Demo 
 SELECT * FROM employee_tbl   
 WHERE daily_typing_pages BETWEEN 170 AND 300;  

No comments:

Post a comment