What are different operators used in SQL?

To perform some operation like select, update or delete on specific set of records in some database using SQL we need some operators with WHERE clause.

The operators used in SQL are

Relational Operators
=                                    Equals to
<>                                  Not Equals to
>                                    Greater than
>=                                  Greater than or equals to
<                                    Less than
<=                                  Less than or equals to
BETWEEN                   For Range between x and y
IN                                  For the values in given list
LIKE                             To provide some pattern                     

Logical Operators
AND
OR
NOT



Comments

Post a Comment

Popular posts from this blog

What is template?

Can we access private members of an instance?

What are wrapper classes in Java?