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

[Amy00]

Hello,

I have a SQL question:

Table: A,
HAS COLUMNS: CASEID, ASSESSID, FUNCTION, DATE

I need to create a SQL that returns all the rows that date match the max date of each case.

Thanks in advance!:

[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
/

[Amy00]

Thank you!
I try to test it!