basic sql - how to pivot using oracle sql

Question

Very basic question

Right now my query is like

select table.a, table.b, table.c from table

A   B    C  

1   2    3

.

I need my output to be

NAME    ID
A       1
B       2
C       3

.

Is there a way that I can pivot my current output or query this table in a different way?

Thanks!

Bob · Accepted Answer · 2014-07-04 02:06:58Z

1

You need UNPIVOT:

select * from table1 unpivot (id for name in (a,b,c));

answered Jul 4, 2014 at 2:06

Bob

1,0658 silver badges10 bronze badges

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

Comments

Alisa · Accepted Answer · 2014-07-03 21:13:13Z

0

Select 'A' as name, (
    select A 
        from table1
        ) as ID
union all
Select 'B', (
    select B 
        from table1
    ) as ID
union all
Select 'C', (
    select C 
        from table1
    ) as ID

answered Jul 3, 2014 at 21:13

Alisa

3,1423 gold badges35 silver badges45 bronze badges

Collectives™ on Stack Overflow

basic sql - how to pivot using oracle sql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related