日期:2014-05-18 浏览次数:20662 次
select a,max(b) b from tb group by a ------解决方案--------------------
select col1,max(col2) as col2 from tb group by col1