Get multiple AVG

Results 1 to 3 of 3

Thread: Get multiple AVG

  1. #1
    Alex T. Guest

    Default Get multiple AVG

    Hi, I was wondering if there is a way to get multiple averages from a database. Essentially using something to this effect:<BR><BR>SELECT AVG(Total1, Total2) AS AvgTotal1, AvgTotal2 FROM tblName<BR><BR>I don&#039;t want to have to have multiple SQL statements (i.e. get average 1, get average 2, etc.). Does anyone kow of a good way to do this?

  2. #2
    Join Date
    Dec 1969

    Default RE: Get multiple AVG

    something like this??<BR><BR>SELECT AVG(Total1) AS AvgTotal1, AVG(Total2) as AvgTotal2 FROM tblName

  3. #3
    Alex T. Guest

    Default RE: Get multiple AVG

    That worked! Thanks...I had done it in a round about way, but this way is much simpler. Thanks again!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts