我如何解决旧版MySQL中缺少where子句子查询的问题？

I've got a table Foo with columns A, B, and C. What I need to get out of this is each distinct value of A, and the value of C in with the row that has the greatest B for that A. I've got a table Foo with columns A, B, and C.