SQL Operators Review
Last Updated: June 23, 2021 11:11:13 AM PDT
Give feedback
SQL allows you to include comparison, logical, or arithmetic operators in your SQL statements. Use this guide to review how they work.
Note: If you don't know the SQL programming language, you can use QueryLink by clicking the Queries button in FinancialLink, EmployeeLink, Student/ Class Info tools, and DataLink.
| Operators | Usage |
|---|---|
| Comparison operators | |
| = | Equal |
| <> | Not equal |
| < | Less than |
| > | Greater than |
| <= | Less than or equal to |
| >= | Greater than or equal to |
| Logical operators | |
| AND | Joins two conditions and returns results when both are true |
| OR | Joins two conditions and returns results when either is true |
| NOT | Negates any logical expression or keywords such as like, null, between, in, and exists |
| Arithmetic operators | |
| + | Addition |
| - | Subtraction |
| / | Division |
| * | Multiplication |
For more information, contact the Data Warehouse team.