第一步:求每组最大数值;
第二部:查找表中对应列值等于最大数值的明细。
select * from A where A.amount in ( select max(amount) from A where month='2月' group by A.area, A.month );
第一步:求每组最大数值;
第二部:查找表中对应列值等于最大数值的明细。
select * from A where A.amount in ( select max(amount) from A where month='2月' group by A.area, A.month );