mysql如何查询多列不重复数据

Question

id score tip
1 1 2
2 1 3
3 2 2
4 3 1
想要的结果是
id score tip
4 3 1
只要某一列出现相同的数据那么那一行就不显示

Answer 1

子查询筛选的方式。

select * from 表名 where score 
in(select score from 表名 group by score having count(score)=1) 
and tip 
in(select tip from 表名 group by score having count(tip)=1)