Database Tutorial

Course Tutorial Site

Site Admin

Lab

without comments

Lab #12: Selective Aggregation

Learn how to use the CASE operator with aggregation functions to transform and report data. This type of approach is known as selective aggregation.

Objectives

You learn how to use the CASE and SUM operators to return a selectively aggregated result set.

Business Scenario

Business analysts write reports that qualify financial transactions by month, quarter, and year. You typically report assets as credits and debits. Debits are shown as positive numbers and debits are shown as negative numbers.

Written by michaelmclaughlin

August 11th, 2018 at 4:11 pm

Posted in