mysql数据查询去重复 select distinct date,cost,price from time orderby date asc
mysql 查询重复数据取其中一条 数据select a.*from t1 as a where i_time=(select max(i_time)from t1 where a.number=number)查询结果
请教大家!mysql查询结果,过滤重复数据? SELECT*FROM table1 t1 LEFT JOIN table2 t2 ONt1.tid=t2.tid group by t2.tid;