MySQL Forums
Forum List  »  General

GROUP BY and NULL values
Posted by: Mason Sklut
Date: June 10, 2020 12:50PM

I've been trying to use GROUP BY but cannot get a workaround for the NULL values. Long story short, this link simulates how our e-commerce store's MySQL database is designed. The query currently works well for most cases, but when there are NULL values it doesn't return the values on a single row.

https://www.db-fiddle.com/f/eDxcjp7VNgdR1t3vhkdRoe/5

Any recommendations?

Options: ReplyQuote


Subject
Written By
Posted
GROUP BY and NULL values
June 10, 2020 12:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.