Attending this event?
Wednesday, April 8 • 3:45pm - 5:00pm
Group By, Having and multi-dimensional Grouping

Sign up or log in to save this to your schedule and see who's attending!

An SQL SELECT can be much more than a simple SELECT * FROM query. Among others it includes with the GROUP BY clause a powerful data aggregation capability. A bunch of aggregate functions allows to count or summarize rows, to calculate the average over multiple rows, to determine the minimum and maximum row value. The GROUP BY clause may be widely known and used, but the HAVING clause which goes hand in hand with the GROUP BY is often a mystery. There may be other secrets waiting for being revealed … or did you know you can create all kinds of sub-totals and grand-total with an SQL GROUP BY?

avatar for Birgitta Hauser

Birgitta Hauser

Fresche Solutions
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany.She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works as... Read More →

Wednesday April 8, 2020 3:45pm - 5:00pm
(D) Commons I
Feedback form isn't open yet.

Attendees (2)