Board index » delphi » Help: summing , averaging, statistical deviation, Min and Max functions

Lawrence Leary

Delphi Developer
Mon, 23 Jul 2001 03:00:00 GMT

Help: summing , averaging, statistical deviation, Min and Max functions

Does anyone know how to sum, avg, min, max, and statistical deviation a
column in a database table?
 
Christoph Kindl

Delphi Developer
Mon, 23 Jul 2001 03:00:00 GMT

Re:Help: summing , averaging, statistical deviation, Min and Max functions


Make Queries on your tables!

Example summarize column values:

SELECT Sum(Itemstotal)
FROM "Customer.db"

Example for max:
SELECT Max(field)
FROM Table

The appripriate function names: min, max, count, sum, avg

Christoph Kindle

Team

Delphi Developer
Mon, 23 Jul 2001 03:00:00 GMT

Re:Help: summing , averaging, statistical deviation, Min and Max functions


Use a TQuery component and the SQL sum, count, min, max and avg functions.

Bill

--
Bill Todd
(Sorry but TeamB cannot answer questions received via email)
(Remove nospam from my email address to contact me for any other reason)

Other Threads

1. max min avg sum in local tables andd queries

2. Min and Max functions

3. min() max() type functions in Delphi?

4. Problem with getting a Databasefields Min-Max-values with BDE-Functions

5. I need help on MAX,MIN,MODE,MEAN and MEDIUM algorithms

6. Average and sum

7. How do you sum averages in SQL

8. SUM COUNT AVERAGE error ?

9. Getting Min/Max/Default/Required Values from Paradox Tables

10. Reportsmith Max/Min problem