一个student表有4个字段,student_id,class,name,age. 用sql语句查找出class,name,age都相同的student_id
参考答案
select group_concat(id),class,name,age from student group by class,name,age having count(id)>1
一个student表有4个字段,student_id,class,name,age. 用sql语句查找出class,name,age都相同的student_id
参考答案
select group_concat(id),class,name,age from student group by class,name,age having count(id)>1