>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 *
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
Hi,
Here's a table of mine
namedate changeDate
n1d1 cd1
n2d1 cd3
n2d2 cd1
n4d1 cd2
n1d2 cd5
n5d1 cd4
n6d2 cd2
I need to select every name for which the changeDate
corresponding
