sql语句查询出数据重复，取唯一数据

select distinct mr.id,ifnull(mr.pid,0) as pid,mr.name from sys_role_res srr left join main_res mr on mr.id=srr.res_id left join sys_role sr on sr.id=srr.role_id left join bas_member_role bmr on bmr.role_id=sr.id left join bas_member bm on bmr.member_id=bm.id where bm.id = 4 and mr.is_delete = 0 and ifnull(mr.permission,0) = 0 order by mr.id

select distinct 查询值name from 表 where 条件

转载于:https://www.cnblogs.com/sho560/p/5363222.html