Tag: SQL Server BETWEEN Operator

Use of BETWEEN Operator in SQL

Use of BETWEEN Operator in SQL: (1) “BETWEEN” operator is used to get values within the specified range. (2) Syntax of “BETWEEN” statement is: SELECT column1, column2, …FROM table_nameWHERE column1 BETWEEN value1 AND value2; (3) Let’s take an example to get records according to the “No.” column is equal to the assigned values as shown. (4) Select the …