sql大全_持续更新

根据名称去重，取最新的数据

count：计数
Max（）：取最大日期
group by：分组
like :查询
distinct：去重

select count(1),a.*,MAX(a.time) from  
a1 a GROUP BY a.name  

 SELECT DISTINCT (a.name),max(a.time),a.*
 FROM a1 a where qhcode like '320%'
 GROUP BY a.name