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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement