This event has ended. Visit the official site or create your own event on Sched.

Talarna lägger upp sessionerna själva och vi har påminnt dem om att göra det. 
Saknar ni någon kontakta gärna talarna direkt själva eller maila styrelsen.

Back To Schedule
Tuesday, October 17 • 12:15 - 13:00
Group By, Having and multi-dimensional Grouping

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
Abstract: 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-totals with SQL?
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.
Audience: Programmers, Database Administrators and Engineers who quite often need to run queries
or built reports that include sub-totals and grand totals. Everybody who is interested in what
can be done with an SQL SELECT statement.

avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Birgitta Hauser - Modernization - Education - Consulting on IBM i
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 October 17, 2017 12:15 - 13:00 CEST