Home > Archive > SQL Anywhere database > July 2005 > Crosstab query problem









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Crosstab query problem
tmlok

2005-07-27, 3:23 am

I am using ASA 7 to handled student's scores. is it possible to write a
crosstab query to convert table_1 into table_2 as below:

Table_1:

student_name subject score
ABC maths 80
ABC physics 55
ABC chemistry 70
KKK maths 45
KKK physics 66
KKK chemistry 34

Table_2

student_name maths physics chemistry
ABC 80 55 70
KKK 45 66 34

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com