如何在SQL中将行合并为单行?
例如:
例如:
SELECT distinct studentID, studentName, MathGrade, SciGrade from vStudentGrade;
输出: StudentID studentName MathGrade SciGrade
1 Zed 89
1 Zed 98
期望的输出:
StudentID studentName MatheGrade SciGrade
1 Zed 89 98