Re: Max

From: Alain <Alain_at_o.fr>
Date: 31 Jan 2003 14:52:36 GMT
Message-ID: <2003131-155236-279747@foorum.com>

Thanks, but it doesn't work... because it's my fault : I haven't given all information :
In fact, I have :

ID TX Date
-- -- -----

1  3  2002-01-01
1  4  2002-05-01
1  5  2002-03-01
2  7  2002-01-01
3  1  2002-02-01
3  8  2003-02-01

And I would want the TX for the max(Date) only for eg ID=1...

Thanks again.

--

Ce message a ete poste via la plateforme Web club-Internet.fr This message has been posted by the Web platform club-Internet.fr

http://forums.club-internet.fr/ Received on Fri Jan 31 2003 - 08:52:36 CST