Skip to main content

System Status: 

SQL Operators Review

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.