Versions des environnements
Network:
Windows 2008 Server
>>I've possibly forgotten something trivial or learned something new today...
>>
>>How, in an sql statement, do you get the min value of, say, 5 values?
>>
>>I try something like SELECT MIN(field1,field2,field3,field4) FROM MYFILE
>>
>>and VFP wants to assume MIN() is aggregation of several rows....
>
>Why not
>
>select min(field1) as min1, min(field2) as field2 ...
>
>lnMin=min(min1, min1, ...)
Don't think that's what he wants. I think in each record, he wants one field that contains the minimum of those field for that record.
Tamar
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement