MySQL Sum Record Values

Like this blog? Consider exploring one of our sponsored banner ads...

In this post I will show you an easy way to group and sum values in records. The most trivial example would be when you have a table of address records and you want to count how many people are from each state:

SELECT `state`, count( `state` ) AS num FROM `records` GROUP BY `state` ORDER BY `num` DESC

You could use a similar syntax to sum the distinct values in any field and count them.

About this entry

You’re currently reading “MySQL Sum Record Values,” an entry on BRADINO

Published:: 3.29.07 / 4pm

Category:: MySQL

Tags:

No comments

Jump to comment form | comments rss [?]

Have your say

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="" highlight="">

About

I was born and raised in Stockton, California (about 45 miles south of Sacramento). In 1999 I moved to San Diego to attend college. During college I started doing freelance web development, gaining invaluable experience.

Many years later I am now a PHP/MySQL Developer working full-time at a leading Online Advertising Agency in Downtown San Diego. Online Advertising is a fast-paced, exciting industry, that I thoroughly enjoy being a part of.

BRADINO

MySQL Sum Record Values

About this entry

No comments

Have your say

About

Recently

Categories