MySQL Forums
Forum List  »  Newbie

Re: Select Help (Again)
Posted by: Donovan Brooke
Date: July 26, 2019 11:43AM

Hello, I think I answered this myself.

I added a unique select field:
IFNULL(far.far_eventid,UUID()) as unq_far_eventid

Then grouped by that instead:
GROUP BY unq_far_eventid

Seems to work. Back to your regularly scheduled programming.

Options: ReplyQuote


Subject
Written By
Posted
July 26, 2019 11:15AM
Re: Select Help (Again)
July 26, 2019 11:43AM


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.