First off, you have "SKILL1" listed twice, which will cause you problems. The "WHERE" clause allows you to restrict which rows of data you are pulling. If you don't need to pull just a subset of your data, then you can exclude the where clause entirely.
On Thursday, May 2, 2013 10:15:00 AM UTC-4, ultratorrent wrote: > > I have problem with my database, i would like to simplify 500 rows of > data( survey form which is done by students)... > but i can't get the result what i want, I stuck at 'WHERE' condition.. > > SELECT Name, Semester,Subject,Category, > round(((Q1+Q2+Q3+Q4+Q5)/25*100),0) AS SKILL1, > 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 WHERE > > -- 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.
