MySQL Forums
Forum List  »  General

Re: How can I get a sum from specific fields in where clause?
Posted by: Bad Programmer
Date: April 08, 2022 10:53AM

As if this isn't complex enough, I have to add 1 thing.
There is another numeric ID, SrvID in the table.

The SUM in TheQuery has to be per specific SrvID.
Something like: SUM(Answer) GROUP BY SrvID of any specific MX > GivenValue
Maybe something like: (SUM(Answer) GROUP BY SrvID, MX) >= GivenValue

Options: ReplyQuote

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.