mysql 查询重复数据取其中一条 数据select a.*from t1 as a where i_time=(select max(i_time)from t1 where a.number=number)查询结果
mysql数据查询去重复 select distinct date，cost，price from time orderby date asc
MySql怎么查询重复的数据 SELECTSUM(num)as '总数'FROMtd_textWHERENAME IN(SELECT NAME FROM td_text GROUP BY NAME HAVING count(NAME)>；1)GROUP BY `name`td_text 表数据：执行sql后
