根据ID按日期顺序检索不同的记录

I've a query :

我有一个问题：

select C.ChapterID, C.ChapterName, TA.TestAllotmentID, 
       T.TestName, S.StudentFname, B.BatchName, TA.UpdatedDate 
from TransTestAllotment TA,
     MstStudent S,
     MstBatchDetails B,
     MstTest T,
     MstChapter C
where TA.StudentID = 47
  and TA.BatchID = 10 
  and T.TestID = TA.TestID
  and S.StudentID = TA.StudentID
  and B.BatchID = TA.BatchID
  and T.ChapterID = C.ChapterID
  and TA.IsAttempted = 'True'
  and TA.IsEvaluated = 'True'
order by TA.UpdatedDate desc
select C.ChapterID,