Select max within max

Hi all, 10.2.x on Linux ... Is there a "neater"/more efficient way of selecting the maximum value for a column based on the maximum value of another column. Gods that reads poorly, I'll try an example ... SomeTable ColX ColY ColZ .... MoreCols A 1 8 .... A 1 9 ....