你可能感兴趣的试题
SELECT sno FROM sc WHERE sname="数据库"AND grade=MAX(grad SELECT sno FROM sc FOR sname="数据库"OR grade＞=MAX(grad SELECT sno FROM sc WHERE sname="数据库"AND grade=(SELECT MAX(grad FROM s SELECT sno FROM sc FOR sname="数据库"OR grade=(SELECT MAX(grad FROM s
SELECT sno FROM sc WHERE sname="数据库"AND grade=MAX(grad SELECT sno FROM sc FOR sname="数据库"OR grade>=MAX(grad SELECT sno FROM sc WHERE sname="数据库"AND grade=(SELECT MAX (grad FROM s SELECT sno FROM sc FOR sname="数据库" OR grade=(SELECT MAX (grad FROM s
SELECT sno FROM sc WHERE sname = "数据库" AND grade = MAX(grade) SELECT sno FROM sc FOR sname = "数据库" OR grade＞=MAX(grade) SELECT sno FROM sc WHERE sname = "数据库" AND grade = (SELECT MAX(grade) FROM sc) SELECT sno FROM sc FOR sname = "数据库" OR grade = (SELECT MAX(grade) FROM sc)
SELECT sno FROM sc WHERE sname="数据库"AND grade=MAX(grade) SELECT sno FROM sc FOR sname="数据库"OR grade>=MAX(grade) SELECT sno FROM sc WHERE sname="数据库"AND grade=(SELECT MAX (grade) FROM sc) SELECT sno FROM sc FOR sname="数据库" OR grade=(SELECT MAX (grade) FROM s
SELECT SNAME FROM S,SC,C WHERE S.SNO=SSNO AND SCNO=CNO AND CNAME=′DB′ SELECT SNAME FROM S WHERE SNO IN(SELECT SNO FROM SC,C WHERE SCNO=CNO AND CNAME=′DB′) SELECT SNAME FROM S WHERE SNO IN(SELECT SNO FROM SC WHERE CNO IN(SELECT CNO FROM C WHERE CNAME=′DB′) ) SELECT SNAME FROM S,C WHERE CNAME=′DB′
SELECT sname FROM student，SELECT cno，grade FROM sc WHERE studensno＝ssno SELECT sname，cno，grade FROM student，course WHERE studensno＝courscno SELECT sname，cname，grade FROM student，course，sc WHERE studensno＝ssno and scno＝course，cno SELECT sname，cno，grade FROM student，sc WHERE studensno＝ssno
1 个，为(Sno,Cno) 1 个，为(Sno,Cno,Tname) 2 个，为(Sno,Sname,Cno)和(Sno,Cno,Tname) 2 个，为(Sno,Sname,Cno)和(Sname,Cno,Tname)
1个，为 (Sno, Cno) 1个，为 (Sno, Cno, Tname) 2个，为 (Sno, Sname, Cno) 和 (Sno, Cno, Tname) 2个，为 (Sno, Sname, Cno) 和 (Sname, Cno, Tname)
Majo=‘计算机’ Major like‘％计算机％’ Majorlike‘_计算机_’ Major =‘*计算机*’
SELECT sno FROM sc WHERE sname="数据库"AND grade=MAX(grad SELECT sno FROM sc FOR sname="数据库"OR grade＞=MAX(grad SELECT sno FROM sc WHERE sname="数据库"AND grade=(SELECT MAX(gradFROM s SELECT sno FROM sc FOR sname="数据库"OR grade=(SELECT MAX(gradFROM s
SELECT sno FROM sc WHERE sname="数据库"AND grade=MAX(grade) SELECT sno FROM sc FOR sname="数据库"OR grade＞=MAX(grade) SELECT sno FROM sc WHERE sname="数据库"AND grade=(SELECT MAX(grade)FROM sc) SELECT sno FROM sc FOR sname="数据库"OR grade=(SELECT MAX(grade)FROM s
SELECT Sname FROM S，SC，C WHERE Sno=SSno AND SCno=Cno AND Teacher=‘LIU’AND Ssex=‘F’ SELECT Sname FROM S WHERE Ssex=‘F’AND Sno IN (SELECT Sno FROM SC WHERE Cno IN(SELECT Cno FROM C WHERE Teacher=‘LIU’)) SELECT Sname FROM S WHERE Ssex=‘F’AND EXISTS (SELECT* FROM SC WHERE SSno=Sno AND EXISTS (SELECT* FROM C WHERE Teacher=‘LIU’)) SELECT Sname FROM S WHERE Ssex=‘F’AND EXISTS(SELECT* FROM SC WHERE SSno=Sno AND EXISTS (SELECT* FROM C WHERE Cno=SCno AND Teacher=‘LIU’))
SELECT sno FROM sc WHERE sname="数据库"AND grade=MAX(grade) SELECT sno FROM sc FOR sname="数据库"OR grade>=MAX(grade) SELECT sno FROM sc WHERE sname="数据库"AND grade=(SELECT MAX(grade)
FROM sC)
SELECT sname FROM R WHERsno='2003%' SELECT sname FROM R WHERE sno LIKE '2003%' SELECT sname FROM R WHERE sno='2003_' SELECT sname FROM R WHERE sno LIKE '2003_'
湘公网安备 43130202000226号