Do it in MySQL if you can. "Use the force" ;-) Besides MIN() and MAX() there are also statistical functions implemented as: AVG(), STDDEV() etc.
See the manual for all functions. Lian Sebe, M.Sc. Freelance Analyst-Programmer www.programEz.net > -----Original Message----- > From: Taylor Lewick [mailto:[EMAIL PROTECTED] > Sent: Monday, July 28, 2003 6:00 PM > To: [EMAIL PROTECTED] > Subject: mysql queries with numbers > > > Question for everyone, I have a database with about 30-60 days > worth of information. Much of it numerical. > Can and should I use SQL to run quereis that will return me the > high/low and average for the time frame, as well as standard deviation, > or should I just get all of the info into an array via perl and > let it do the crunching? > > Thanks, > Taylor > > **************************************************************** > Please Note > The information in this E-mail message is legally privileged > and confidential information intended only for the use of the > individual(s) named above. If you, the reader of this message, > are not the intended recipient, you are hereby notified that > you should not further disseminate, distribute, or forward this > E-mail message. If you have received this E-mail in error, > please notify the sender. Thank you > ***************************************************************** > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]