Average SQL command

Average SQL command examples, imagine that we have a table with four columns ID, NAME, CLASS, and MARK, and we want to get the average for all students' marks:

Code:

SELECT avg( mark ) FROM 'student'

You can also name the header us "as" :

Code:

SELECT AVG(mark) as avg_mark FROM 'student'

You can also get average for specific groups :

Code:

SELECT class, avg( mark ) as avg_mark FROM `student` GROUP BY class

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind

Posts: 2715
Have thanks: 74 time

Page 1 of 1

[ 1 post ]

Related Posts to : Average SQL command
C++ Average example -
Average of an array. Please help -
BETWEEN SQL COMMAND -
SQL LIKE query Command -
SQL LOCATE command -
SQL GROUP BY Command -
SQL ALTER Command -
SQL DISTINCT Command -
PHP echo command -
SQL COUNT Command -

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com