distinct 多字段去重复

distinct 后面只能跟一个去重复的条件，那结果想以一个字段去重复查多个字段怎么办呢

 

select id,admin_id from feature_and_admin a group by a.admin_ID

 

select *,count(distinct a.admin_ID) from feature_and_admin a group by a.admin_ID

select * from  feature_and_admin a where  a.id in(select max(id) from feature_and_admin group by admin_id)

select id,min(a.admin_ID) from feature_and_admin a group by a.admin_ID
s