General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Max(Maximum of field1,field2 or field3)
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only