SQL Operators

SQL Arithmetic Operators

In SQL, operators are symbols or keywords used to perform operations on data. Here's a rundown of some common SQL operators:

1. Arithmetic Operators:

• '+' (Addition)

• '-' (Subtraction)

• '*' (Multiplication)

• '/'(Division)

• '%' (Modulus)

2. Comparison Operators:

• '=' (Equal to)

• '!=' or '<>' (Not equal to)

• '<' (Less than)

• '>' (Greater than)

• '<=' (Less than or equal to)

• '>=' (Greater than or equal to)

3. Logical Operators:

• AND (Logical AND)

• OR (Logical OR)

• NOT (Logical NOT)

4. Concatenation Operator:

• || (Used to concatenate strings in some SQL dialects like Oracle)

5. Pattern Matching Operators:

• LIKE (Matches a pattern)

• IN (Matches any value in a list)

• BETWEEN (Matches a range)

6. NULL-related Operators:

• IS NULL (Tests for NULL values)

• IS NOT NULL (Tests for non-NULL values)

7. Aggregate Functions:

• COUNT() (Counts the number of rows)

• SUM() (Calculates the sum of values)

• AVG() (Calculates the average)

• MIN() (Finds the minimum value)

• MAX() (Finds the maximum value)

8. Assignment Operator:

• = (Assigns a value to a variable)

These are the fundamental operators used in SQL queries to perform various operations like filtering data, performing calculations, and more.