Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Good ideas for aggragates

Status
Not open for further replies.

Luzian

Programmer
Nov 27, 2005
103
US
Already existing, we have Max, Min, Avg, Sum, and whatever else there is.
I was thinking Median and Mean would be a nice extension. Can anyone think of others that could be useful?
 
oh! oh! i know a good one!! GROUP_CONCAT()

if i had a dollar for every time somebody posts a question in this forum which could be solved trivially with this function, why, i'd be a fair bit richer than i am now

GROUP_CONCAT is a mysql function described on this page: GROUP BY (Aggregate) Functions

:)

r937.com | rudy.ca
 
Mean is the same as average, right?

Median: faq183-6220



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Probably. I haven't used math in a scholastic manner, in years.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top