论坛 › 技术交流 › 如何用sql语句查询表中某列不重复的所有项 group by

墨裔 发表于 2022-1-27 20:20:13

如何用sql语句查询表中某列不重复的所有项 group by

如果是 选择不重复列.


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 表

查看完整版本: 如何用sql语句查询表中某列不重复的所有项 group by