2. PHPRunner General questions
  3. Using sum function in SQL query editor
This topic is locked

Using sum function in SQL query editor

 		11/18/2007 12:55:37 PM
PHPRunner General questions
F
 Fawaz author

How do I write this query in the SQL editor?

SELECT sum( mark ) FROM `student`



It gave me an error function sum does not exist.
Any help is really appreciated.
Thanks,

Fawaz
J
 		Jane 11/19/2007

Fawaz,
try to use this query:

SELECT

sum(mark) as summark

FROM `student`

group by IDField