怎么检索不重复的记录并不是select distinct [name] from [table]这个意思。比如“张三、李四、张三”3条记录。我只想要李四。因为张三重复了。一条sql语句能不能做到?[解决办法]
select [name] from [table] group by [name] having count(1) =1