How to pivot table in sql into 2 columns in SQL

Asked Nov 09 '22 at 10:37

Active Nov 09 '22 at 10:42

Viewed 27 times

I have the data like picture below

Now I want to Pivot the table above into this format

student_code  test_type        score
20005997      quiz1_listening  20.00
20005997      quiz1_vocabulary 20.00
20008143      quiz1_listening  20.00
20008143      quiz1_vocabulary 20.00
...

The problem is the score column has many variants and also how to make score is relevant to each student's test type?

edited Nov 09 '22 at 10:42

Thom A

88,727
11
45
75

asked Nov 09 '22 at 10:37

Tung Nguyen

1

This is *unpivoting* not pivoting. – Thom A Nov 09 '22 at 10:40

How to pivot table in sql into 2 columns in SQL

0 Answers0