Convert Rows to Columns Using PIVOT in Snowflake

Often, there are requirements, where we need to summarize a table and show the results in columns. i.e, Converting Rows to columns, Snowflake supports this operation using a PIVOT function

Here's my Sales table:

PIVOT Example:

select * from sales
    pivot(sum(amount) for month in ('Jan', 'Feb', 'Mar', 'Apr')) as p;

+-------+-------+-------+-------+-------+
| EMP_ID| 'Jan' | 'Feb' | 'Mar' | 'Apr' |
|-------+-------+-------+-------+-------|
|     1 | 5000  |  6000 | 5000  | 3000  |
|     2 | 8000  |  3000 | 7000  | 4000  |
+-------+-------+-------+-------+-------+

Ryan-Dallas

posted on 24 Oct 18