SQL去重

from t a where not exists( select * from ( select min(id) ,name from t group by name) b where a.id=b.id)

 

 

 

SQL去重

标签：select   where   重复数据   from   title   数据   主键   复数   分析