Please help me to write following sql. I am confused about how
to get it.
following is a problem and the sample data set

code cparentid ddate cdesc

01 10 01/01/99 ABC
02 10 05/01/99 DEF
03 10 03/01/99 PQR
04 20 04/01/99 PPP
05 20 06/01/99 KOP
06 20 03/01/99 RAP

Now, I want to get the details of that record which has highest
date in every group.(cparentid)

for example,
for group of cparentid = 10 the highest date would be 05/01/99
for group of cparentid = 20 the highest date would be 06/01/99

so I need two records in my result set

code cparentid ddate cdesc
02 10 05/01/99 DEF
05 20 06/01/99 KOP

Please help me with above query as I am stuck on it and don't know
how to solve it.

Thank you in advance

Thanks
Mark