SQL面试题

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面试题

标签：