>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
I would do this to obtain those records
select cid, ;
max(date) as MaxDate ;
from table1 ;
group by campo2 into cursor Tempo1
Then I woud do a join with the original table to complete the needed fields.
Note that the field Date is no what you expect if you include it into the first query.
Oscar
Précédent
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