How can I get result that the date is the max date of a group?

[slimdave]

Read SQL Reference for details of analytic functions.

Select
   caseid,
   assessid,
   function,
   date
from
   (
   Select
      caseid,
      assessid,
      function,
      date,
      Max(date) Over (Partition By caseid)
         max_date
   From
      A
   )
Where
   date = max_date
/