Common Methods for changing rows of Oracle Columns

Common Methods for changing rows of Oracle columns 1. Converting rows and columns with fixed columns such as student subject grade --------- ---------- student1 language 80 www.2cto.com student1 mathematics 70 student1 English 60 student2 language 90 student2 mathematics 80 Stu ...... Convert to students statistics on Chinese and mathematical English student1 80 70 60 student2 90 80 100 ...... The statement is as follows: Java code select student, sum (decode (subject, 'China', grade, null) "", sum (decode (subject, 'mat', grade, null) "Mathematics", sum (decode (subject, 'English ', grade, null) "English" from table group by student;