BEx Get Latest Record

Hello Everyone,

I have posted similar thread earlier but did not get correct response. So trying my luck again.

I have some queries to be created to get latest records, for example, to get latest document number (can be based on date).

A B C

1 1 10/10/2008

1 1 11/10/2008

1 1 12/10/2008

2 2 10/01/2008

2 2 11/01/2008

2 2 12/01/2008

I just need records 3 (for A =1 and latest C) and 6 (for A = 2 and latest C).

Did anyone implement same scenario? If yes, please tell me how you were able to do that. Any help in this regard is appreciated.

Regards,

Madhav