SQL Operators - TeachMeSoft

SQL Operators








Operator Aritmatika SQL

OperatorDescriptionExample
+AddTry it
-SubtractTry it
*MultiplyTry it
/DivideTry it
%ModuloTry it

Operator SQL Bitwise

OperatorDescription
&Bitwise AND
|Bitwise OR
^Bitwise exclusive OR

Operator Perbandingan SQL

OperatorDescriptionExample
=Equal toTry it
>Greater thanTry it
<Less thanTry it
>=Greater than or equal toTry it
<=Less than or equal toTry it
<>Not equal toTry it


Operator Senyawa SQL

OperatorDescription
+=Add equals
-=Subtract equals
*=Multiply equals
/=Divide equals
%=Modulo equals
&=Bitwise AND equals
^-=Bitwise exclusive equals
|*=Bitwise OR equals

Operator Logika SQL

OperatorDescriptionExample
ALLTRUE if all of the subquery values meet the conditionTry it
ANDTRUE if all the conditions separated by AND is TRUETry it
ANYTRUE if any of the subquery values meet the conditionTry it
BETWEENTRUE if the operand is within the range of comparisonsTry it
EXISTSTRUE if the subquery returns one or more recordsTry it
INTRUE if the operand is equal to one of a list of expressionsTry it
LIKETRUE if the operand matches a patternTry it
NOTDisplays a record if the condition(s) is NOT TRUETry it
ORTRUE if any of the conditions separated by OR is TRUETry it
SOMETRUE if any of the subquery values meet the conditionTry it





















Disqus comments