No Content Found
COMPARISON OPERATORS
=, !=, <> ---- TEST FOR EQUAL, NOT EQUAL, NOT EQUAL
>, >=, <, <= ---- TEST GREATER THAN, GREATER THAN OR EQUAL TO, LESS THAN, LESS THAN OR EQUAL TO
BETWEEN AND ---- CHECK FOR RANGE BETWEEN AND INCLUDING TWO VALUES
LIKE ---- SEARCH FOR A MATCH IN STRING, USING THE WILDCARD SYMBOLS % (ZERO OR MULTIPLE CHARACTERS) OR _ (ONE CHARACTER)
IN ( ) ---- TEST FOR A MATCH IN A SPECIFIED LIST OF VALUES IS NULL,
IS NOT NULL ---- CHECK WHETHER IS NULL (NO VALUE), IS NOT NULL
Group by parameters: COUNT, MAX, MIN, SUM.