AWS – Amazon Redshift announces support for PIVOT and UNPIVOT SQL operators

Amazon Redshift now supports PIVOT and UNPIVOT SQL operators that can help you transpose rows into columns and vice versa with high performance, for data modeling, data analysis, and data presentation. You can also use PIVOT and UNPIVOT to more easily migrate from your existing data warehouse systems to Amazon Redshift.

Read More for the details.