mysql max value plus associated value

Asked Nov 23 '17 at 09:10

Active Nov 23 '17 at 09:10

Viewed 20 times

This correctly returns the max date value.

SELECT MAX(DateEnd) FROM Balances WHERE SourceId = " & hResultSource!id

I would like to also recover a another value (BalEnd) from the same record

SELECT MAX(DateEnd), BalEnd FROM Balances WHERE SourceId = " & hResultSource!id & " GROUP BY BalEnd"

This returns a strange value for BalEnd

Any help would be appreciated

asked Nov 23 '17 at 09:10

Bill Lancaster

Have a look at the second answer (the one with more votes). This answers your question. It is a duplicate, although the question title and accepted answer can be misleading. – fancyPants Nov 23 '17 at 09:30
`GROUP BY BalEnd` means you get a separate row for each different value of `BalEnd`. – Barmar Nov 23 '17 at 09:59
Thank you, the MySQL documention provided the answer – Bill Lancaster Nov 23 '17 at 11:32

0 Answers0