SQL Statement Clause Review

Last Updated: May 14, 2021 2:07:19 PM PDT

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.