How to combine datas with same column and ignore null values in mysql

Question

I'm just going to ask how to query combine datas with same column and ignore all null values

actual table:

 id |   first_name  |   last name  |    age   |   unique_id 
  1 |      Doe      |              |          |         111
  2 |               |     John     |          |         111
  3 |               |              |     32   |         111
  4 |      Reeves   |              |          |         222
  5 |               |      Keanu   |          |         222

wanted query result :

      first_name  |   last name  |    age   |   unique_id 
          Doe     |     John     |     32   |      111
          Keanu   |     Reeves   |          |      222

Thanks!!

Tim Biegeleisen · Accepted Answer · 2021-12-07 07:13:07Z

2

Aggregate by unique_id and use MAX:

SELECT
    unique_id,
    MAX(first_name) AS first_name,
    MAX(last_name) AS last_name,
    MAX(age) AS age
FROM yourTable
GROUP BY
    unique_id;

answered Dec 7, 2021 at 7:13

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

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

1 Comment

lowbiecoder Over a year ago

Awesome!!! Thanks bud!

Collectives™ on Stack Overflow

How to combine datas with same column and ignore null values in mysql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related