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