MySQL Forums
Forum List  »  Newbie

mysql view with a variants column
Posted by: Jim Weisbin
Date: August 29, 2021 08:16AM

In MySQL, I have a table with columns A,B,C,and D. I need a view that would show me another column E, that would have the count of all rows where A, B, and C are the same, but ignoring D. I would call column E "variants". I'm struggling with trying to figure out how this can be done.

Options: ReplyQuote


Subject
Written By
Posted
mysql view with a variants column
August 29, 2021 08:16AM


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.