使用嵌套查询,得到在SC表中Grade高于90分的学生的基本信息,正确的SQL语句是( )。
选项:
A:Select * from Student where Sno = (Select Sno from SC where Grade >90);
B:Select * from Student where Sno In (Select Sno from SC where Grade >90);
C:Select * from Student where Sno Not In (Select Sno from SC where Grade >90);
D:Select * from Student where Sno Exists (Select Sno from SC where Grade >90)
发布时间:2024-05-16 20:51:38