原结构
查询：使用 IN:select * from TEST where IDD in (select min(IDD) from TEST group by ID);使用JOIN：select * from TEST a join (select min(IDD) as IDD from TEST group by ID)b on a.IDD=b.IDD ;
去重后显示所有列
原文：https://www.cnblogs.com/liyunchuan/p/11510343.html
