Presenting Vertical Data Horizontally
July 10, 2013 Victor Pisman
Presenting “vertical” data in a “horizontal” format is a challenging task in data management. Here is one method you can use to make SQL carry out this type of transformation. Consider table CUSTGRP, which has two fields: a customer ID and a group code. Notice that one customer can have multiple group codes.
Here’s one way to |