[SQL] 사용되는 연산자 정리

SQL에서 사용되는 연산자를 간단하게 정리해봤다.

Table Of Contents

SELECT 5 + 3 AS Sum, 10 - 4 AS Difference, 6 * 7 AS Product, 8 / 2 AS Division;

SELECT 10 % 3 AS Remainder, MOD(10, 3) AS Modulus;

SELECT TRUE IS TRUE AS IsTrue, FALSE IS FALSE AS IsFalse;

SELECT TRUE IS NOT FALSE AS IsNotFalse, FALSE IS NOT TRUE AS IsNotTrue;

SELECT (1 < 5 AND 5 > 3) AS AndResult, (TRUE && TRUE) AS LogicalAnd;

SELECT (1 > 5 OR 5 > 3) AS OrResult, (TRUE || FALSE) AS LogicalOr;

SELECT 5 = 5 AS IsEqual, 'abc' = 'abc' AS StringEqual;

SELECT 5 != 3 AS NotEqual, 'abc' <> 'xyz' AS StringNotEqual;

SELECT 5 > 3 AS GreaterThan, 3 < 5 AS LessThan;

SELECT 5 >= 5 AS GreaterOrEqual, 3 <= 5 AS LessOrEqual;

SELECT 10 BETWEEN 5 AND 15 AS InRange, 20 BETWEEN 5 AND 15 AS NotInRange;

SELECT 10 NOT BETWEEN 20 AND 30 AS OutOfRange, 25 NOT BETWEEN 10 AND 15 AS AlsoOutOfRange;

SELECT 5 IN (1, 3, 5, 7) AS IsInSet, 'apple' IN ('orange', 'banana', 'apple') AS StringInSet;

SELECT 5 NOT IN (1, 2, 3, 4) AS IsNotInSet, 'pear' NOT IN ('orange', 'banana', 'apple') AS StringNotInSet;

SELECT 'apple' LIKE 'a%' AS StartsWithA, 'banana' LIKE '%na' AS EndsWithNa;

SELECT 'cat' LIKE 'c_t' AS MatchesPattern, 'dog' LIKE 'd__' AS MatchesLength;