带有联接的SQL查询将为所有其他行重复最上面一行的数据

下面的SQL查询检索并重复所有其他行的最上面一行的数据。

SELECT 
    Student.StuRollNo, Student.StuName, Student.StuFName, 
    (SELECT TOP 1 M.SubjectObtMarks 
     FROM Marking M 
     WHERE M.SubjectID = 'SubUrdu' 
       AND M.ExamID = 1) AS Urdu,
    (SELECT TOP 1 M.SubjectObtMarks 
     FROM Marking M 
     WHERE M.SubjectID = 'SubEng' 
       AND M.ExamID = 1) AS Eng,
    (SELECT TOP 1 M.SubjectObtMarks 
     FROM Marking M 
     WHERE M.SubjectID = 'SubPhy' 
       AND M.ExamID = 1) AS Phy,
    (SELECT TOP 1 M.SubjectObtMarks 
     FROM Marking M 
     WHERE M.SubjectID = 'SubChem' 
       AND M.ExamID = 1) AS Chem,
    (SELECT TOP 1 M.SubjectObtMarks 
     FROM Marking M 
     WHERE M.SubjectID = 'SubBio' 
       AND M.ExamID = 1) AS Bio,
    (SELECT TOP 1 M.SubjectObtMarks 
     FROM Marking M 
     WHERE M.SubjectID = 'SubIsl' 
       AND M.ExamID = 1) AS Isl,
    (SELECT TOP 1 SUM(Marking.SubjectObtMarks) 
     FROM Marking 
     WHERE ExamID = 1) AS ObtMarks
FROM 
    Exam, Student 
INNER JOIN 
    PrimaryData ON Student.StuRollNo = PrimaryData.StuID 
INNER JOIN 
    Section ON Section.SectionID = PrimaryData.SectionID 
WHERE 
    Section.SectionName = 'M1' 
    AND Exam.ExamID = 1;

以下是它检索到的内容:

数据库关系图:

请帮我解决这个问题。谢谢!