MySQL DQL 去重教程表代码

垃圾的撒娇的风景色谱发票为菩萨的搭配覅色谱法配色【】we9rfpqsoedufoiewrun拍摄跑调覅就怕是东风破一坚实的皮肤的胜多负少的  的食品发票速度发票首都非破损的赔付喷水电机 山东分批进隧道排是家拍摄地交水电费萨顶顶 上当受骗飞机票睡大觉佛奥圣诞节哦放假撒到附近收到了甲方收到后僵尸洞给按实际大佛给将三大排放量较为动设计福利卡三等奖佛给爱神的箭发票里煎熬手动  【】JFLAJSDLFJSADLFJLKSADAJFOIASDJFHSADFJLSADAJHFLSADA,;FJKSADHFLJSDH　　　　萨拉丁会计分录撒大家来看风景时代浪费空间收到了 破碎带飓风破圣诞节安排了放假撒离得近服务商 圣诞节福利卡时间段浪费空间安山东覅今后【i爱神的箭恢复了卡萨丁撒大家哦放假撒多垃圾分离圣诞节福利卡萨京东覅静安寺店铺撒大路口附近拉三等奖

CREATE TABLE sutdy(
    id  INT(50) NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(50) NOT NULL,
    email VARCHAR(50),
    PRIMARY KEY(id)
)ENGINE=INNODB DEFAULT CHARSET=utf8;


INSERT INTO `sutdy`(`id`,`name`,`email`)
VALUES(1,"杨开","yangkai@qq.com"),(2,"杨开","yangkai@qq.com"),(3,"杨开","yangkai@qq.com"),(4,"杨开","yangkai@qq.com"),(5,"玉如梦","yurumeng@qq.com"),(6,"玉如梦","yurumeng@qq.com"),(7,"玉如梦","yurumeng@qq.com"),(8,"玉如梦","yurumeng@qq.com"),(9,"苏颜","suyan@qq.com"),(10,"苏颜","suyan@qq.com"),(11,"苏颜","suyan@qq.com"),(12,"苏颜","suyan@qq.com"),(13,"苏颜","suyan@qq.com"),(14,"苏颜","suyan@qq.com"),(15,"苏颜","suyan@qq.com"),(16,"苏颜","suyan@qq.com"),(17,"夏凝裳","xianingshagn@qq.com"),(18,"夏凝裳","xianingshagn@qq.com"),(19,"夏凝裳","xianingshagn@qq.com"),(20,"夏凝裳","xianingshagn@qq.com"),(21,"夏凝裳","xianingshagn@qq.com"),(22,"夏凝裳","xianingshagn@qq.com"),(23,"扇轻罗","shanqingluo@qq.com"),(24,"扇轻罗","shanqingluo@qq.com"),(25,"扇轻罗","shanqingluo@qq.com"),(26,"扇轻罗","shanqingluo@qq.com"),(27,"扇轻罗","shanqingluo@qq.com"),(28,"扇轻罗","shanqingluo@qq.com"),(29,"雪月","xueyue@qq.com"),(30,"雪月","xueyue@qq.com"),(31,"雪月","xueyue@qq.com"),(32,"雪月","xueyue@qq.com"),(33,"雪月","xueyue@qq.com"),(34,"雪月","xueyue@qq.com"),(35,"雪月","xueyue@qq.com"),(36,"祝情","zhuqing@qq.com"),(37,"祝情","zhuqing@qq.com"),(38,"祝情","zhuqing@qq.com"),(39,"祝情","zhuqing@qq.com"),(40,"祝情","zhuqing@qq.com"),(41,"祝情","zhuqing@qq.com"),(42,"祝情","zhuqing@qq.com");



SELECT email FROM `sutdy` -- 普通查询
SELECT DISTINCT `email` FROM `sutdy` -- 去掉重复查询