If you have an auto_increment or other unique recno you can do:
select a.* from file a , file b where a.timefield = b.timefield and
a.recno != b.recno
Robert Reed wrote:
No worries mate, that is exactly what I need, and the
number I've got are 32 and when I subtract the ones
more than a year old
No worries mate, that is exactly what I need, and the
number I've got are 32 and when I subtract the ones
more than a year old I've less than 10. I can do the
legwork. :)
Thanks.
--- Mike Johnson <[EMAIL PROTECTED]> wrote:
> From: Mike Johnson
>
> > From: Robert Reed [mailto:[EMAIL PROTECTED]
From: Mike Johnson
> From: Robert Reed [mailto:[EMAIL PROTECTED]
>
> > This seems like it should be easy, and I'd be happy
> > for a simple reference to where in the manual or in
> > Paul's book I can find the answer. I am wanting to
> > find basically the inverse of a SELECT DISTINCT
> > opera
From: Robert Reed [mailto:[EMAIL PROTECTED]
> This seems like it should be easy, and I'd be happy
> for a simple reference to where in the manual or in
> Paul's book I can find the answer. I am wanting to
> find basically the inverse of a SELECT DISTINCT
> operation. I have a table with a column
