Re: finding last date

From: valigula <valigula_at_gmail.com>
Date: 23 May 2007 12:23:02 -0700
Message-ID: <1179948182.604632.64630@p77g2000hsh.googlegroups.com>

On 23 mayo, 21:12, Robert Hicks <sigz..._at_gmail.com> wrote:
> On May 23, 2:49 pm, Frank van Bortel <frank.van.bor..._at_gmail.com>
> wrote:
>
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
>
> > fitzjarr..._at_cox.net wrote:
>
> > Such is the price
>
> > > you pay for not providing accurate details regarding what you are
> > > trying to do.
>
> > Homework?
>
> Thanks for the cynicism...but no. It is work work.
>
> Robert

Thakns for your help but ..

group by ?? good try already did that!!

Problem is , i need to return 7 others columns from that query fitering only from the cod that must be unique and the date that can be different even null. I also did the alias trick but i does not work either.

thanks Mladen that was where i was stack ... A. Received on Wed May 23 2007 - 14:23:02 CDT