OPERATORS

SQL Fundamentals

Data Retrieval

Data Modification:

Operator	Description	Syntax	Example	Output
+	Addition	expression1 + expression2	20 + 10	30
-	Subtraction	expression1 - expression2	20 - 10	10
*	Multiplication	expression1 * expression2	20 * 10	200
/	Division. Expression on the left is the dividend and expression on the right is the divisor.	dividend / divisor	20 / 10	2
%	Modulo. Expression on the left is the dividend and expression on the right is the divisor. Output is the remainder of the division.	dividend % divisor	20 % 8	4

ProductID	ProductName	Price
1	HD TV	1000
2	Play Station	400
3	MacBook	2000
4	IMAC	1500
5	IPOD	200
6	XBOX	500
7	MODEM	100
8	Nintendo	200
9	Speakers	100
10	Printer	200
11	SLR Camera	1000
12	Tablet	600

ProductID	ProductName	Price	Addition	Subtraction	Multiplication	Division	Modulo
1	HD TV	1000	1010	990	10000	66	6
2	Play Station	400	410	390	4000	26	1
3	MacBook	2000	2010	1990	20000	133	5
4	IMAC	1500	1510	1490	15000	100	2
5	IPOD	200	210	190	2000	13	4
6	XBOX	500	510	490	5000	33	3
7	MODEM	100	110	90	1000	6	2
8	Nintendo	200	210	190	2000	13	4
9	Speakers	100	110	90	1000	6	2
10	Printer	200	210	190	2000	13	4
11	SLR Camera	1000	1010	990	10000	66	6
12	Tablet	600	610	590	6000	40	5

Here Addition, Subtraction and Multiplication columns are self-explanatory. Division column returns back the quotient when the Price (dividend) is divided by 15 (divisor). It truncates the fractional part of the quotient. Modulo column returns back the reminder when the Price (dividend) is divided by 7 (divisor).

Select

Alias

Sorting

Operators

Join

Grouping Datasets

ROLLUP and CUBE

Built-In Functions

Insert

Select Into

Update

Delete and Truncate

Merge

Transactions

CTE