SQL Operator

SQL Comparison Operators:

SQL Arithmetic Operators Operator Description

 = 

 It checks if two operands values are equal or not, if the values are queal then condition becomes true. 

!= 

It checks if two operands values are equal or not, if values are not equal, then condition becomes true.  <> 

It checks if two operands values are equal or not, if values are not equal then condition becomes true. 

> 

It checks if the left operand value is greater than right operand value, if yes then condition becomes true. 

< 

It checks if the left operand value is less than right operand value, if yes then condition becomes true. 

>= 

It checks if the left operand value is greater than or equal to the right operand value, if yes then condition becomes true. SQL

SQL Arithmetic Operators Operator Description 

<= 

It checks if the left operand value is less than or equal to the right operand value, if yes then condition becomes true. 

!< 

It checks if the left operand value is not less than the right operand value, if yes then condition becomes true. 

!> 

It checks if the left operand value is not greater than the right operand value, if yes then condition becomes true. 

SQL Logical Operators Operator Description 

All It compares a value to all values in another value set. 

AND 

It allows the existence of multiple conditions in an SQL statement. 

ANY 

It compares the values in the list according to the condition. Between It is used to search for values that are within a set of values. 

IN 

It compares a value to that specified list value. 

NOT 

It reverses the meaning of any logical operator. 

OR 

It combines multiple conditions in SQL statements. 

EXIST 

It is used to search for the presence of a row in a specified table. 

LIKE 

It compares a value to similar values using wildcard operator.