Comparison Operators in SQL
The below table shows all comparison operators in SQL :
| Operator | Description |
|---|---|
| = | The SQL Equal Operator checks if the values of two operands are equal. |
| != | The SQL Not Equal Operator checks if the values of two operands are not equal. |
| >= | The SQL Greater Than Equals to Operator checks if the value of the left operand is greater than or equal to the value of the right operand. |
| < | The SQL Less Than Operator checks if the value of the left operand is less than the value of the right operand. |
| > | The SQL Greater Than Operator checks if the value of the left operand is greater than the value of the right operand. |
| <= | The SQL Less Than Equals to Operator checks if the value of the left operand is less than or equal to the value of the right operand. |
SQL Comparison Operators
SQL Comparison Operators are used to compare two values and check if they meet the specific criteria. Some comparison operators are = Equal to, > Greater than , < Less than, etc.
Contact Us