merge values in two rows in an sql table appear in two columns of one row

Question

I need help in SQL. I have a table with this structure.

this structure :

What I need is a query to return the data like this.

this :

Thank you very much in advance!

Kind regards, bgergoe

conditional aggregation or pivot. research these and try them and then show us what you try if you fail. — S3S, Jun 08 '17 at 13:33
Ah, the good old EAV anti-pattern, the bane of DBAs everywhere. — Joel Coehoorn, Jun 08 '17 at 14:05

score 5 · Accepted Answer · answered Jun 08 '17 at 13:35

5

This has been asked and answered dozens of times but it is super simple to write out the code. Conditional aggregation is pretty straight forward and the code is far less obtuse than PIVOT. Here is how you would go about this.

SELECT ID
    , MAX(CASE WHEN Field = 'name' THEN Value END) AS name
    , MAX(CASE WHEN Field = 'phone number' THEN Value END) AS PhoneNumber
FROM YourTable
GROUP BY ID

answered Jun 08 '17 at 13:35

Sean Lange

33,028
3
25
40

You're awesome, thanks a lot for the prompt assistance, have a nice day! – bgergoe Jun 08 '17 at 13:50

merge values in two rows in an sql table appear in two columns of one row

1 Answers1

Linked