distinct去重
distinct可以对某个字段进行去重,但是如果你用了多个字段那他就是在这些字段同时满足的情况下去重,这样的去重就是去重所有的字段,换句话就是必须是完全一样的数据才会被去重(此方法用的少),如图
SELECT examid,firstanswer,thirdanswer from answer;
SELECT distinct examid,firstanswer,thirdanswer from answer ;
group by去重
group by是对某个字段分组, 换个话就是对单个字段或者查询多个字段中根据某个字段进行去重(此方法比较常见)
SELECT examid,firstanswer,thirdanswer from answer;
SELECT examid,firstanswer,thirdanswer from answer GROUP BY examid
开始把自己的经验分享出来了,如有错误请大佬指导