Skip to main content

System Status: 

SQL Statement Clause Review

SQL allows you to use statement clauses in a query. Use this guide to review how the clauses 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.

Statement clause Usage
from Specifies the table(s) that contain the data to be retrieved
Note: The from clause is always required.
where Specifies the selection condition(s) by which data is retrieved
order by Specifies the ordering or sorting of rows
group by Groups the resulting rows in sets
having Allows a search condition when used with group by clause
For more information, contact the Data Warehouse team.