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

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!:

Read SQL Reference for details of analytic functions.

Code:

---

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
/

---

Thank you!
I try to test it!:)