根据名称去重,取最新的数据
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
根据名称去重,取最新的数据
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