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
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
What are wildcards and triggers in SQL
ReplyDelete