如何用sql语句查询表中某列不重复的所有项 group by
2022/03/04 14:50:25
如果是 选择不重复列.
[SQL]
反向
select distinct a from 表
[SQL]
- select * from table b inner join (select a from table group by a having count(a)=1) as c on b.a=c.a
反向
select distinct a from 表