WHERE S.SNO=SPJ.SNO AND S.CITY='上海' Р结果:Р f. SELECT DISTINCT JNO FROM SPJ WHERE JNO IN(SELECT JNO FROM S,SPJ WHERE S.SNO=SPJ.SNO AND S.CITY='上海')Р或者:РSELECT DISTINCT JNO FROM SPJ,S WHERE S.SNO=SPJ.SNO AND S.CITY='上海' Р结果:Р h. SELECT DISTINCT JNO FROM SPJ WHERE JNO NOT IN(SELECT JNO FROM S,SPJ WHERE S.SNO=SPJ.SNO AND S.CITY='天津')Р结果:Р i. UPDATE P SET COLOR='蓝' WHERE COLOR='红';SELECT * FROM PР结果:Р j. UPDATE SPJ SET SNO='ES3' WHERE SNO='S5' AND JNO='J4' AND PNO='P6';SELECT * FROM SPJР 结果:Р k.(first).先删除S表中的记录РDELETE FROM S WHERE SNO='S2';SELECT * FROM SР结果:Р (second).再删除SPJ表中得记录РDELETE FROM?SPJ WHERE SNO='S2';SELECT * FROM SPJР结果:Р l. INSERT INTO SPJ VALUES('S2','P4','J6',200);SELECT * FROM SPJР结果:Р出现的问题:只出现一些查询不会用相应的程序语句Р解决方案(列出遇到的问题和解决办法,列出没有解决的问题):Р看了答案,有些查询得分两步;有的查询得利用嵌套查询,从而进一步掌握了嵌套查询的要义
全文预览
