SQL Server BETWEEN Condition (Operator)The SQL Server BETWEEN operator is used to retrieve values within a specified range in a SELECT, INSERT, UPDATE, or DELETE statement. Syntax: Parameter Explanationexpression: It specifies a column or a calculation. value1 and value2: These values specify inclusive range that is used by expression for comparison. BETWEEN operator with Numeric ValueRetrieve all employees from table "Employees" where id is between 7 and 13. Output: Or Output: BETWEEN operator with NOT OperatorRetrieve all employees from table "Employees", where it satisfies the following BETWEEN NOT condition. Output: Or Output:
Next TopicIS NULL Operator
|