问题:
列出SC表中所有考试不及格的学生的学号Sno(无须重复),其SQL语句为( )
A.
SELECT ALL Sno FROM SC WHERE Grade<60;
B.
SELECT Sno FROM SC WHERE Grade<60;
C.
SELECT DISTINCT Sno FROM SC WHERE Grade IS NULL;
D.
SELECT DISTINCT Sno FROM SC WHERE Grade<60;
列出SC表中所有考试不及格的学生的学号Sno(无须重复),其SQL语句为( )
A.
SELECT ALL Sno FROM SC WHERE Grade<60;
B.
SELECT Sno FROM SC WHERE Grade<60;
C.
SELECT DISTINCT Sno FROM SC WHERE Grade IS NULL;
D.
SELECT DISTINCT Sno FROM SC WHERE Grade<60;
Copyright © 2024 www.daanwo.com All Rights Reserved |