Jim Metcalf
asked on
query question - where clause with a max involved
I hope you can deduce what i am asking from the excel spreadsheet
it has 3 tables listed and the desired results. I don't know how to write this query.
the problem area is the gallons table.
please refer to spreadsheet.
it has to do with selecting row data from a max value where the max value is not known. and then a 2nd max also
experts-exchange.xlsx
it has 3 tables listed and the desired results. I don't know how to write this query.
the problem area is the gallons table.
please refer to spreadsheet.
it has to do with selecting row data from a max value where the max value is not known. and then a 2nd max also
experts-exchange.xlsx
ASKER
im confused
what do you mean
what do you mean
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys!
2. Put
max(isnull(column1,0))...
in case the column is null.