- Reads 5
- Votes 0
- Parts 1
- Time <5 mins
Ongoing, First published Jul 09, 2024
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=3tCym9ZkEdkAll Rights ReservedTable of contents
Sign up to add SQL Operators Basics for New Users to your library and receive updates
or
You may also like
