Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Max(Maximum of field1,field2 or field3)
Message
De
22/10/2001 14:10:48
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Max(Maximum of field1,field2 or field3)
Divers
Thread ID:
00571775
Message ID:
00571775
Vues:
56
t1, t2, t3
10, 15, 7
12, 6, 8
5, 4, 11
1st record: maximum=15
2nd record: maximum=12
3rd record: maximum=11
I need the maximum of these 3 records (maximum of 15, 12 & 11) = 15.
I guess what I need is the maximum of t1, t2 or t3 of all the records.

SELECT IIF(t1>t2,IIF(t1>t3,t1,t3),IIF(t2>t3,t2,t3)) as xRet from table1
This only gives the maximum of t1, t2 or t3 per record.
How do I get the maximum of that maximum?

Thank you all!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform