Attending this event?
Welcome to the Common Europe Congress 2023 agenda site.

Number of registered participants 

May 28th - 350 (End of Early Bird)
May 31st - 356
June 2nd - 362

For more registration and information about our CEC, please go here:
Back To Schedule
Tuesday, June 13 • 14:05 - 15:05
Group By, Having and multi-dimensional Grouping

Log in to save this to your schedule, view media, leave feedback 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?

Learning Objectives:
In this session you’ll learn the basic use of the GROUP BY and HAVING clauses as well as the use of multiple aggregate functions. You’ll also discover how NULL values can affect the result returned by aggregate functions. It will be demonstrated how easily all kinds of sub-totals and grand-totals can be built. You’ll also learn how to use the CASE clause for building pivot tables.

avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →

Tuesday June 13, 2023 14:05 - 15:05 CEST
03-Prague B
Feedback form isn't open yet.