SQL去重后按最新时间显示查询

select A,B,max(C) from test group by A,B having count(*)>1;