赞
踩
1.查询某列值只有一条的数据
select t1.* from table1 t1 where t1.所要查询列 in (select t2.所要查询列 from table1 t2 group by t2.所要查询列 having count(1)=1);