单项选择题

有关系S(SNO, SNAME, SDEPT,SAGE),C(CNO, CNAME),SC(SNO, CNO, GRADE)。其中SNO是学生号,SNAME是学生姓名,SDEPT是系别,SAGE是学生年龄, CNO是课程号,CNAME是课程名称,GRADE是成绩。下列查询语句语法正确的是(  )。
A、DELETE FROM S,SC
WHERE S,Sno=SC.Sno AND Sname LIKE '李%'
B、UPDATE FROM SC
SET Grade=Grade+10
WHERE Sno = (SELECT Sno FROM SC WHERE Grade <60)
C、SELECT S1.Sno,Sname
FROM S1 JOIN SC
ON S1.Sno = SC.Sno
WHERE Grade >= min(Grade)
D、SELECT S1.Sno,Sname
FROM (SELECT Sno,Sname FROM S
            WHERE Sdept='计算机' ) S1 JOIN SC
ON S1.Sno = SC.Sno
WHERE Grade >=60

题目列表

你可能感兴趣的试题

问答题

婴儿腹泻有明显周围循环障碍者,扩容时宜选用的液体及其量分别是

答案: 正确答案:等张含钠液20ml/kg
微信扫码免费搜题