sql编程求使用各种邮件的用户

create table studs(
id int,
name varchar(30),
mail varchar(50)
);
insert into studs values(1,'Jack','jack@qq.com');
insert into studs values(1,'Mary','329438484k@qq.com');
insert into studs values(1,'Alex','838dd_kkd@126.com');
insert into studs values(1,'Jerry','kdkdk@163.com');
insert into studs values(1,'Jack','jack333@126.com');
insert into studs values(1,'Jack','jack939@gmail.com');
insert into studs values(1,'Jack','jaddddcddk@qq.com');
insert into studs values(1,'Jack','jaasdfck@qq.com');

select mail, name from studs group by mail,name

以mysql 为例

先将email分类，再去重name