SELECT TABLE1.*
FROM (Select B,Max(C) From 表 Group By B TABLE2 ) , X TABLE1
WHERE TABLE1.B=TABLE2.B and TABLE1.C=TABLE2.C