sql去重并展示所有信息

//去重并展示所有信息
//注意:is_delete = 0如果加在外侧数据会减少,所以放在去重sql里
select * from company_user where id in (select min(id) from company_user where is_delete = 0 group by quality_level);