Thanks for reply. but your trick won't work.

When you issue

select cparentid,max(ddate) from table1 group by cparentid

This will not give me the details of the record which has highest date.
This will give group's last records information .

Mark