<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have a MySQL table similar to:<br />
id<br />
agent<br />
location<br />
commission<br />
date<br />
qty<br />
comment<br />
<br />
Sometimes agents take a deposit to go towards their commission, and they take may also more then they are entitled to for a particular sale, so the commission field can contain a positive or negative value.<br />
<br />
I need to do a report &nbsp;GROUPed BY location AND agent, but only include those groups (and list all sales details: date, qty, comment,) where the total commission <b>for that group is &gt;&nbsp;0</b>. &nbsp;How can I do that? &nbsp;Would I need a sub-query here?<br />
<br />
Any help would be greatly appreciated.<br />
<br />
Thanks
</div>
</div>


Hi Experts,

I have a MySQL table similar to:
id
agent
location
commission
date
qty
comment

Sometimes agents take a deposit to go towards their commission, and they take may also more then they are entitled to for a particular sale, so the commission field can contain a positive or negative value.

I need to do a report  GROUPed BY location AND agent, but only include those groups (and list all sales details: date, qty, comment,) where the total commission for that group is > 0.  How can I do that?  Would I need a sub-query here?

Any help would be greatly appreciated.

Thanks

Filter by grouped totals

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.