|
|
Posted by Bob Bedford on 05/23/05 12:32
"Alvaro G Vicario" <alvaro_QUITAR_REMOVE@telecomputeronline.com> a écrit
dans le message de news: 13bwff5w9iibj.7kybkobyuwzy$.dlg@40tude.net...
> *** Bob Bedford wrote/escribió (Mon, 23 May 2005 09:44:28 +0200):
>> id datefrom dateto
>>
>> In my case, I'd like to show the last date for any ID.
>
> Then you don't need datefrom and dateto but MAX(datefrom) and MAX(dateto)
MAX needs to group by, and having 20 fields in my query, should I group by
all fields ? Also this field may be empty sometimes.
Isn't there any other solution ?
Navigation:
[Reply to this message]
|