SQL Operators Basics for New Users

SQL (Structured Query Language) operators are essential components used to perform various operations on data stored in a database. Here's a basic overview of SQL operators for new users:

1. Arithmetic Operators
These operators are used to perform arithmetic operations on numeric data.

- Addition ('+'): Adds two numbers.
'''sql
SELECT 5 + 3; -- Result: 8
'''

- Subtraction ('-'): Subtracts one number from another.
'''sql
SELECT 5 - 3; -- Result: 2
'''

- Multiplication (''): Multiplies two numbers.
'''sql
SELECT 5 3; -- Result: 15
'''

- Division ('/'): Divides one number by another.
'''sql
SELECT 15 / 3; -- Result: 5
'''

- Modulus ('%'): Returns the remainder of a division.
'''sql
SELECT 5 % 3; -- Result: 2
'''

2. Comparison Operators
These operators are used to compare two values and return a boolean result (TRUE or FALSE).

https://www.youtube.com/watch?v=3tCym9ZkEdk