DISQUS

Website
http://www.codespatter.com
Original page
http://codespatter.com/2008/07/22/conditions-on-count-or-sum-in-mysql/
Subscribe
All Comments
Community
Top Commenters
- itjobs1
  1 comment · 2 points
- billymcclure
  1 comment · 1 points
- Ben Bangert
  1 comment · 2 points
- jakubmusil
  1 comment · 1 points
- dobrych
  1 comment · 3 points
Popular Threads

Kuroki Kaze · 1 year ago

Thanks, useful.
Luciano · 1 year ago

It's a good tip, thanks.
suresh vijayan · 1 year ago

hi
myself suresh...a great programmer...if anybody needs help..just mail to me.
buellart · 4 months ago

ah, thanx Greg, that gave me a kick in the back!
jarnail · 3 months ago

Can we do count and sum in single SQL?

I have a table where i need SUM of a field as will as I have to COUNT total effected rows.

Any idea?
jarnail · 3 months ago

Hello

I just did it.

I used this:
SELECT count(products_id) as count_products , SUM( reviews_rating ) as total FROM TABLE WHERE products_id=".$product_id;
Greg Allard · 3 months ago

yeah that looks like it should work