Get last child of parents

#21

Linchi,

Thanks for your help, I got the same answer that works from another NG.

Thanks again,

LVP

"Linchi Shea" <LinchiShea (AT) discussions (DOT) microsoft.com> wrote

Quote:

select c.c1_id, c.pk1_id
from Child c join (
select p.pk1_id, max(c1.eDate) as eDate
from Parent p join Child c1 on p.pk1_id = c1.pk1_id
group by p.pk1_id ) as t
on c.pk1_id = t.pk1_id and c.eDate = t.eDate

Linchi

"LVP" wrote:

I have the need to get the last child of each parent.

Note: eDate if what points me to the Last child not the c1_id

Parent ( pk1_id , etc..)

Child ( c1_id, pk1.id, eDate, type_id)

Need the pattern to do this

tried max(), top 1 etc.. just can not figure it out. been driving me
nuts
for half an hour.

Thanks

LVP

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Get last child of parents

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Re: Get last child of parents - 05-28-2008 , 12:02 PM