I don't know if it is possible for you to Create your table in another way if so this is the other way :

SELECT A, MAX(B)...