Jump to content

Archived

This topic is now archived and is closed to further replies.

MeanMrMustard

Limiting Count()

Recommended Posts


I'm working on an incentive site.

Each employee has a monthly goal - say 20 products.

Each product has two incentive values - 2.00 if the total number of products sold is less than 10. $5.00 if products sold equal 11 or more.

I'm trying to do a Sum and Count all in the same query.

I want to know the sum of the first 10 products and then the sum of the remaining products. I have about 30 products each with different values so I can't limit it by value.

Any help would be appreciated...

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.