Getting all Rows but Only the Latest Ones

[gosoccer]

Hi,
In a subject query filter, I have to add the filter to get of data like below and I need to get only the latest rows based on the update date.

DATA

CASE ID     LAST SYSTEM UPDATE 
1111          09/09/2016
1111          08/09/2015
1222          09/09/2016
1222          07/09/2015

So trying to get the following row in the Subject Query:
RESULT
1111          09/09/2016
1222          09/09/2016

Could you please help!

Thanks so much for your time.

[gosoccer]

Ok, I'm using the following,

LAST SYSTEM UPDATE  = maximum(LAST SYSTEM UPDATE  for CASE ID )

What do you think? This should give me all the records but only the most up-to-date ones based on
CASE ID. Right?

Thx

[AnalyticsWithJay]

Ok, I'm using the following,

What do you think? This should give me all the records but only the most up-to-date ones based on
CASE ID. Right?

Thx

Correct  :)

[gosoccer]

Thanks for confirming. Works great!