MySQL Forums
Forum List  »  Newbie

Querie number of rows based on fields
Posted by: Jordan Pritt
Date: July 14, 2017 08:39AM

Sorry if this is in some way a duplicate but I'm having a difficult time finding the right way to address this issue.

Assuming one has a table containing three columns how would one go about quering all the rows where the first cell = X and the last cell equals 'yes' or the second cell = X and the third cell = 'yes'

The end goal is to only qurie the amount of rows that are yes when compared to the amount of rows that are no based on a percentage.

i.e. Only qurie X where yes are greater than 10% of no

Any insight on how to go about this would be greatly appreciated as I am rather new to using MySQL even a point in the right direction would be welcomed! Thanks for any advice

Options: ReplyQuote


Subject
Written By
Posted
Querie number of rows based on fields
July 14, 2017 08:39AM


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.