General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Max(max of 3 fields) + corresponding field
t1,t2,t3,goal1,goal2,goal3
10,4,33,5,6,7
55,77,8,2,3,4
21,14,1,9,10,11
1st record: maximum=33
2nd record: maximum=77
3rd record: maximum=21
I need the maximum of these 3 records (maximum of 33,77 & 21) = 77
(maximum of t1, t2 or t3 of all the records),
PLUS the corresponding goal. For this example, it would be goal2=2.
(t1 corresponds to goal1, t2 corresponds to goal2, etc.)
SELECT MAX(IIF(t1>t2,IIF(t1>t3,t1,t3),IIF(t2>t3,t2,t3))) as xRet from table1
This gives me the max. of t1,t2, & t3 of all the records (thanks for all your help to come up with this one),
but how do I get the corresponding goal from the corresponding record??
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