how to move data from one column to another column's row in postgres?

Question

How I start coding to get below output.

id	Column1
1	A1
2	A2
3	A1
4	A2
5	A1
6	A1

output should be below.

id	Column1	Column1.1	Column1.2
1	A1	A1
2	A2		A2
3	A1	A1
4	A2		A2
5	A1	A1
6	A1	A1

What is the logic behind your result

Jens
– Jens

2022-06-20 14:24:38 +00:00
Commented Jun 20, 2022 at 14:24 — Jens
– Jens, Commented Jun 20, 2022 at 14:24

D-Shih · Accepted Answer · 2022-06-20 14:35:45Z

1

We can try to use CASE WHEN expression to make it.

SELECT id,
       Column1,
       CASE WHEN Column1 = 'A1' THEN Column1 END 'Column1.1',
       CASE WHEN Column1 = 'A2' THEN Column1 END 'Column1.2'
FROM T

answered Jun 20, 2022 at 14:35

D-Shih

46.5k6 gold badges37 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

how to move data from one column to another column's row in postgres?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related