查询语句去重distinct

前言

此篇用到的表如下

CREATE TABLE `yytest` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `stu_id` int(10) NOT NULL,
  `c_name` varchar(20) DEFAULT NULL,
  `istester` varchar(50) DEFAULT NULL,
  `grade` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `test`.`yytest` (`id`, `gender`, `birth`, `stu_id`, `c_name`, `istester`) VALUES (1, 0, 18, 1, NULL, NULL);
INSERT INTO `test`.`yytest` (`id`, `gender`, `birth`, `stu_id`, `c_name`, `istester`) VALUES (2, 1, 15, 2, NULL, NULL);
INSERT INTO `test`.`yytest` (`id`, `gender`, `birth`, `stu_id`, `c_name`, `istester`) VALUES (3, 0, 15, 3, NULL, NULL);
INSERT I