Using the tools you have on-hand, you may enhance your queries and expand the functionality using expressions and subqueries. Learn how to exclude a group where more than one value may be possible (such as student groups, service indicators), select a first or last term and related data, list multiple values of a field in one field (listagg-thanks Troy!), calculate a term GPA as it was before repeats were calculated, etc., using subqueries and expressions!
The Higher Education User Group (HEUG) is a 501(c)(3) nonprofit dedicated to helping member institutions effectively manage administrative technologies to improve the student and user experience. We support executives, managers, and staff who select, deploy, integrate, and manage multiple systems by providing education, professional resources, and opportunities to connect with peers. As the digital landscape continues to evolve, HEUG adapts to meet the changing needs of its members while remaining committed to its core mission of connection, education, and advocacy.
Higher Education User GroupMesa, AZ 85212 United States
support@heug.org
M-F 8 AM to 5 PM MST
Join HEUG
Community Council
Interest Areas
Resources
Alliance Conference
Global Meetings
Online Webinars
Code of Conduct
Privacy Policy
Terms of Service
Copyright 2026 Higher Education User Group, Inc.
Copyright © 2026 Higher Education User Group, Inc.