sql 按xxx属性分组，取yyy属性最大值所在行的数据

SELECTx.* 
FROMb_purchase_order_detail x 
WHEREx.TAX_AMOUNT = ( SELECT max( y.TAX_AMOUNT ) FROM b_purchase_order_detail y WHERE x.MATERIAL_ID = y.MATERIAL_ID ) 
ORDER BYx.MATERIAL_ID;