ABSTRACT

Aggregate functions and group by clause are described in this chapter. Those functions and GROUP BY Clause are widely used in industries to generate business reports. The readers will see AVG, COUNT, MAX, MIN, SUM functions examples for Oracle SQL, T-SQL and MySQL. GROUY BY with HAVING condition is discussed in this chapter. By the end of the chapter readers will be able to use the aggregate functions and group by clause.