SQL avoid null fields

Question

This is my table

I need to write a query for getting a dataset like below.(Avoid null fields and group by id)

Please give me direction....

Tim Biegeleisen · Accepted Answer · 2016-09-09 05:27:18Z

5

Try grouping by the id:

SELECT id,
       MAX(col1) AS col1,
       MAX(col2) AS col2,
       MAX(col3) AS col3,
       MAX(col4) AS col4
FROM test
GROUP BY id

The reason this works is that in SQL Server MAX ignores NULL values, so only the single VARCHAR value (e.g. 'ABC') will be retained during the grouping operation.

The data in your test table appear to be the intermediate step of a pivot query.

answered Sep 9, 2016 at 5:27

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

2 Comments

Jacky Over a year ago

@weeraa please mark as answer if that helped to resolve your issue

weeraa Over a year ago

@jacky : Done. :)

Collectives™ on Stack Overflow

SQL avoid null fields

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related