Skip to content

Instantly share code, notes, and snippets.

View deepa4lok's full-sized avatar

Deepa Venkatesh deepa4lok

4 followers · 5 following
View GitHub Profile
@deepa4lok
deepa4lok / crosstab.sql
Created November 22, 2019 08:49 — forked from romansklenar/crosstab.sql
PostgreSQL "pivot table" example using tablefunc extension
CREATE EXTENSION tablefunc;
CREATE TABLE sales(year int, month int, qty int);
INSERT INTO sales VALUES(2007, 1, 1000);
INSERT INTO sales VALUES(2007, 2, 1500);
INSERT INTO sales VALUES(2007, 7, 500);
INSERT INTO sales VALUES(2007, 11, 1500);
INSERT INTO sales VALUES(2007, 12, 2000);
INSERT INTO sales VALUES(2008, 1, 1000);
INSERT INTO sales VALUES(2009, 5, 2500);