MySQL Forums
Forum List  »  General

Advanced Search
New Topic

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?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
GROUP BY and NULL values
Mason Sklut
June 10, 2020 12:50PM
Re: GROUP BY and NULL values
Mason Sklut
June 10, 2020 01:12PM
Re: GROUP BY and NULL values
Peter Brawley
June 10, 2020 03:43PM
Re: GROUP BY and NULL values
Mason Sklut
June 10, 2020 07:27PM
Re: GROUP BY and NULL values
Peter Brawley
June 10, 2020 09:17PM
Re: GROUP BY and NULL values
Mason Sklut
June 11, 2020 05:12AM
Re: GROUP BY and NULL values
Peter Brawley
June 11, 2020 08:45AM
Re: GROUP BY and NULL values
Mason Sklut
June 11, 2020 08:54AM
Re: GROUP BY and NULL values
Peter Brawley
June 11, 2020 09:47AM
Re: GROUP BY and NULL values
Mason Sklut
June 11, 2020 09:54AM
Re: GROUP BY and NULL values
Peter Brawley
June 11, 2020 10:06AM


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.