SQL 分组后获取其中一个字段最大值的整条记录

select * from (  

select id,name,counts,createDate,row_number() over(partition bynameorderby createDate desc) rn  

from testTable  

) t where t.rn <=1  

http://shop107857222.taobao.com/

转载于:https://blog.51cto.com/mawushou/1345607