combine rows from table with NUM columns

Question

I have this table:

Product | Qtdy | Price 
A | NULL | 123.00 
A | 23 | NULL

How Can I represent convert like that?

Product | Qtdy | Price 
A | 23 | 123.00

Which means group by product using Null to return value print in the next line?

Thank you

Answer 1

Here's one way.

SELECT Product, MAX(Qtdy), MAX(Price)
FROM table
GROUP BY Product

The better answer is to clean up your data so it isn't ditry.

• Andre Silva: Thanks danblack! Works well.