How to get multiple SQL columns into one column?

Question

I have a SQL query "Select A,B,C,(A+B+C) as Total from Test" and the result is

How to get the same result in only two columns like

Gordon Linoff · Accepted Answer · 2018-11-25 21:38:54Z

2

You can "unpivot". My preferred method is apply:

Select v.name, v.value
from Test t cross apply
     (values ('A', A), ('B', B), ('C', C)) v(name, value);

The total is not in your result set, but that can also easily be added in.

answered Nov 25, 2018 at 17:08

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Comments

plalx · Accepted Answer · 2018-11-25 17:10:07Z

1

You can unpivot using UNION ALL. I still prefer Gordon's solution though.

SELECT 'A' AS name, A AS [value] FROM Test
UNION ALL
SELECT 'B', B FROM Test
UNION ALL
SELECT 'C', C FROM Test

answered Nov 25, 2018 at 17:10

plalx

43.8k7 gold badges77 silver badges94 bronze badges