Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Max(Maximum of field1,field2 or field3)
Message
From
22/10/2001 14:10:48
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Max(Maximum of field1,field2 or field3)
Miscellaneous
Thread ID:
00571775
Message ID:
00571775
Views:
58
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!
Next
Reply
Map
View

Click here to load this message in the networking platform