SQL Server Multiple Rows into One row

Question

I have a table with lot of records. I provided a sample of 1 record (4 rows)

Need the rows to be combined as follows

How can this be achieved?

Gordon Linoff · Accepted Answer · 2020-05-18 18:54:31Z

2

You can use aggregation:

select col1, max(col2), max(col3), max(col4)
from t
group by col1;

Note that the data you describe sounds like it comes from an aggregation query. Usually this is more easily fixed by fixing that query and fixing the group by keys.

answered May 18, 2020 at 18:54

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Collectives™ on Stack Overflow

SQL Server Multiple Rows into One row

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