Re: need help for a query

2004-08-24 Thread Stephen E. Bacher
>select name >from mytable a >where changedate > > (select changedate > from mytable b > where a.name=b.name > and a.changedate != b.changedate); > >or: > >select name >from mytable a >where exists > (select *

Re: need help for a query

2004-08-23 Thread Matt Warden
Hi Claire, On Mon, 23 Aug 2004 14:52:29 -0700 (PDT), Claire Lee <[EMAIL PROTECTED]> wrote: > Hi, > Here's a table of mine > > namedate changeDate > n1d1 cd1 > n2d1 cd3 > n2d2 cd1 > n4d1 cd2 > n1d2 cd5 > n5