Max

Hello,

I have :

TX Date
-- -----

3   2002-01-01
4   2002-05-01
5   2002-03-01

I would like to get TX value where Date is the max date (4 in this sample) without using order by desc and selecting the first line...

Thanks in advance.

--

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 - 05:40:09 CST