select id,name from student where id in ( select id from score having count(id)>=2 );以上这段语句有没语法错误.SQL语句

来源：学生作业帮助网编辑：六六作业网时间：2024/11/24 18:00:34

selectid,namefromstudentwhereidin(selectidfromscorehavingcount(id)>=2);以上这段语句有没语法错误.SQL语句selectid,na

select id,name from student where id in ( select id from score having count(id)>=2 );以上这段语句有没语法错误.SQL语句
select id,name from student where id in ( select id from score having count(id)>=2 );
以上这段语句有没语法错误.
SQL语句

select id,name from student where id in ( select id from score having count(id)>=2 );以上这段语句有没语法错误.SQL语句
select id,name from student where id in ( select id from score GROUP BY id having count(id)>=2 ); 这应该这样写吧