SQL Combine 2 rows into 2 columns

Question

I have a table that contains entries like this:

enter image description here

I would like to transfor it to something like this:

enter image description here

Can't find how to do so with a group by only. Am I missing anything?

Thanks in advance for your help

Mudassir Hasan · Accepted Answer · 2014-06-30 03:57:26Z

3

SELECT Entity,
       MAX(CASE WHEN Type=Auto THEN Value ELSE NULL END) AS ValueAuto,
       MAX(CASE WHEN Type=Manual THEN Value ELSE NULL END) AS ValueMaual
FROM tableName
GROUP BY Entity

answered Jun 30, 2014 at 3:57

Mudassir Hasan

29k21 gold badges104 silver badges135 bronze badges

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

2 Comments

Antony Francis Over a year ago

For completeness we will need to include region the group by and in the select list.

goul Over a year ago

Thank you. How would you do if the 'Value' was actually string?

Chennakrishna · Accepted Answer · 2014-06-30 06:38:42Z

0

above query returns the good values if we have only two types, If I don't know how many groups are there in the table, dynamically how can do with the case statement.

Use UN-PIVOT is the best options to solve the above requirements.

answered Jun 30, 2014 at 6:38

Chennakrishna

1816 bronze badges

Collectives™ on Stack Overflow

SQL Combine 2 rows into 2 columns

2 Answers 2

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Related