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 A1DCSLab84848068A1DCSLab72848084" 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.
