PDA

Click to See Complete Forum and Search --> : Sql command for working out the average

Luna_Etoile
October 23rd, 2004, 08:11 AM
Hello, can anyone please tell me the sql command to work out the average of a set of given figures.

Thanks.

Luna
khp
October 23rd, 2004, 10:04 AM
Hello, can anyone please tell me the sql command to work out the average of a set of given figures.


MySQL has an avg() function http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html . I don't know about other databases.
hspc
October 23rd, 2004, 03:37 PM
I don't know about other databases.
MS Sql server , Access has the same function :)
Luna_Etoile
October 24th, 2004, 04:09 PM
thanks