SQL pivot query in Oracle

Question

I have a table like this:

name----address----type----value
 a      finland    color    120
 a      finland    wage     500

what i want is to show color and wage values as columns:

name----address----color----wage
 a      finland     120     500

MikkaRin · Accepted Answer · 2016-09-23 14:45:28Z

3

SELECT *
FROM   (SELECT name, address, type, value
        FROM   table)
PIVOT  (SUM(value)  FOR (type) IN ('color', 'wage'));

edited Sep 23, 2016 at 14:45

answered Mar 21, 2014 at 13:08

MikkaRin

3,08422 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

J21042 Over a year ago

I had to put single quotes around 'color' and 'wage', otherwise it produces a "non-constant expression is not allowed for pivot|unpivot values" error.

Collectives™ on Stack Overflow

SQL pivot query in Oracle

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related