StudentName EN CH HO
Peter 89 78 99
May 34 88 66
SELECT A.StudentName,A.SubjectScore as EN,B.SubjectScore as CH,C.SubjectScore as HO
From students A,students B,students C
WHERE A.StudentName=B.StudentName AND B.StudentName=C.StudentName
AND A.StudySubject=‘语文‘ AND B.StudySubject=‘数学‘
AND C.StudySubject=‘英语‘
2016-06-28 19:11:01
SQL面试题
标签：