以下面一张表为例,想要stu_id去重,有几种方法
-- 方法1
select distinct(stu_id) from score;
-- 方法2
select stu_id from score group by stu_id;
-- 方法3
select stu_id from score union select stu_id from score;
以下面一张表为例,想要stu_id去重,有几种方法
-- 方法1
select distinct(stu_id) from score;
-- 方法2
select stu_id from score group by stu_id;
-- 方法3
select stu_id from score union select stu_id from score;