Joining columns with null marks into one row

Question

I used a sub select to get the data I want. I'm struggling to merge it all into one row now though.

This is an example of the result where its bike but there are loads on them:

bike    bike    null    null    bike    6       6    
bike    bike    null    null    bike    null    null     
bike    bike    2       2       bike    null    null

Any idea how I can merge or 'join', if you will, these rows together to act as one?

Output would ideally be bike 2 2 6 6.

The large data output above is literally the output of the query I ran.

What is the query? Is this the output of the query? What is the wanted output, how rows should be "merged"? — ypercubeᵀᴹ, Jun 24 '16 at 08:43
Shouldn't it be bike bike 2 2 bike 6 6? Question remains vague. How about the SQL you use to get this result? What database do you use? How about when one null would hold a value? Which one to take? — Marco, Jun 24 '16 at 08:51

score 1 · Accepted Answer · answered Jun 24 '16 at 09:36

It's difficult without seeing your query, but you want to aggregate on your fields with null values if you want to remove the redundant rows.

This query would give you one row of data in this example, I'm not sure how you mean to get your output where you are removing two rows.

SELECT
     Field1
    ,Field2
    ,MAX(Field3) Field3
    ,MAX(Field4) Field4
    ,Field5
    ,MAX(Field6) Field6
    ,MAX(Field7) Field7
FROM TableName
GROUP BY
     Field1
    ,Field2
    ,Field5

Joining columns with null marks into one row

1 Answers1