Data Transposition, SQL

Question

I have in my SQL table about 5000 rows. I have two columns 'name1' and 'name2'. And now, tricky part. I have to data from 'name1' put into 'name2' and data from 'name2' should be in 'name1'... I know that I can make extra column just for this action but I have a feeling that is a better and faster way to do it. Important part that I cannot do it for all the rows but for particular part (about 50%), simply for 'WHERE type = 'p' ' ;-)

Sorry that I firstly forgot about this part ;-) But your answer wasn't stupid. I just change columns names and later data from on of them just put into second (for this rows that I didn't want to affect second column was empty so I was able to do it). Although I'm still intereseting is there any way in SQL to make something like 'exchange' data from two columns ;-) — Michal Olszowski
– Michal Olszowski, Commented Jan 21, 2014 at 12:36
have a look on this one. stackoverflow.com/questions/37649/… — I kiet
– I kiet, Commented Jan 21, 2014 at 13:04

Zbynek Vyskovsky - kvr000 · Accepted Answer · 2015-12-28 12:54:29Z

Use case-when to conditionally rename the columns:

SELECT CASE WHEN t.type = 'p' THEN t.name2 ELSE t.name1 END as name1, CASE WHEN t.type = 'p' THEN t.name1 ELSE t.name2 END as name2, t.type FROM (your original select) t;

Collectives™ on Stack Overflow

Data Transposition, SQL

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related