You want to group the data? You would need to use this: SELECT Name, Semester, Subject, Category, round(SUM((Q1+Q2+Q3+Q4+Q5)/25*100),0) AS SKILL1, round(SUM((Q6+Q7+Q8+Q9+Q10)/25*100),0) AS SKILL2, round(SUM((Q11+Q12+Q13+Q14+Q15)/25*100),0) AS SKILL3, round(SUM((Q16+Q17+Q18+Q19+Q20)/25*100),0) AS SKILL4 from epat GROUP BY Name, Semester, Subject, Category
On Thursday, May 2, 2013 10:52:18 AM UTC-4, ultratorrent wrote: > > thanks~ > SELECT Name,Semester,Subject,Category, > round(((Q1+Q2+Q3+Q4+Q5)/25*100),0) AS SKILL1, > round(((Q6+Q7+Q8+Q9+Q10)/25*100),0) AS SKILL2, > round(((Q11+Q12+Q13+Q14+Q15)/25*100),0) AS SKILL3, > round(((Q16+Q17+Q18+Q19+Q20)/25*100),0) AS SKILL4 > from epat... > > ermm...after i run the statement above,the result showed some of the rows > of contents is same > e.g : > Name | Semester | Subject | Category | Skill1 | Skill2 | SKill3 | Skill4 > A1DCSLab72848084A2DCSLab72848076" > and what i want is sum up the values which have the same contents, how can > i make it...? > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
