你可能感兴趣的试题
SELECT sno FROM sc WHERE cno=“c1”AND cno=“c2” SELECT sno FROM sc WHERE cno=“c1”AND SELECT sno FROM sc WHERE cno=“c2” SELECT sno FROM sc WHERE cno=“c1”UNION SELECT sno FROM sc WHERE cno=“c2” SELECT sno FROM sc WHERE cno=“c1”AND sno IN(SELECT sno FROM sc WHERE cno=“c2”)
GROUP BY grade GROUP BY sno ORDER BY grade ORDER BY sno
SEI，ECT sno FROM SC WH ERE grade BETWEEN O AND 60 SELECT sno FROM SC WHERE grade＜60 SELECT sno FROM SC HAVlNG grade BETWEEN O AND 60 SELECT sno FROM SC HAVING grade＜60
SELECT sno FROM sc WHERE cno="c1"AND cno="c2" SELECT sno FROM sc WHERE cno="cl'，AND SELECT sno FROM sc WHERE cno="c2" SELECT sno FROM sc WHERE cno="cl" UNION SELECT sno FROM sc WHER：E cno="c2" SELECT sno FROM sc WHERE cno="cl"AND sno IN(SELECT sno FROM sc WHERE cno="c2")
SELECT S.SN,SC.C#,SC.GRADE
FROMS
WHERE S.S#=SC.S# SELCECT S.SN,SC.C#,SC.GRADE
FROM SC
WHERE S.S#=SC.GRADE SELECT S.SN,SC.C#,SC,GRADE
FROM S,SC
WHERE S.S#：SC.S# SELSECT S.SN,SC.C#,SC.GRADE
FROM S,SC
ALTER TABLE SC SET GRADE+10 WHERE CNO='DB' ALTER TABLE SC SET GRADE=GRADE+10 WHERE CNO='DB' UPDATE SC SET GRADE+10 WHERE CNO='DB' UPDATE SC SET GRADE=GRADE+10 WHERE CNO='DB'
SELECT SN,SC#,SGRADE FROMS WHERE S#=SS# SELCECT SN,SC#,SGRADE FROM SC WHERE S#=SGRADE SELECT SN,SC#,SC,GRADE FROM S,SC WHERE S#：SS# SELSECT SN,SC#,SGRADE FROM S,SC
ALTER TABLE SC SET GRADE+10 WHERE CNO='DB' ALTER TABLE SC SET GRADE=GRADE+10 WHERE CNO='DB' UPDATE SC SET GRADE+10 WHERE CNO='DB' UPDATE SC SET GRADE=GRADE+10 WHERE CNO='DB'
GROUP BY grade GROUP BY sno ORDER BY grade ORDER BY sno
湘公网安备 43130202000226号