徐州工程學(xué)院數(shù)據(jù)庫答案-資料下載頁
2025-06-26 19:40本頁面
【正文】 CnFROM CWHERE TEACHER=‘周亮’(2) SELECT S, SnFROM SWHERE Sa23 AND Sex=‘男’(3) 方法一：SELECT Cn, TEACHERFROM CWHERE C IN(SELECT CFROM SCWHERE S=‘S3’)方法二：SELECT Cn, TEACHERFROM C, SCWHERE = AND =‘S3’ 方法三：SELECT Cn, TEACHERFROM C WHERE EXISTS (SELECT *FROM SC WHERE = AND S=‘S3’)(4) 方法一：SELECT SnFROM SWHERE Sex=‘女’ AND EXISTS(SELECT *FROM SCWHERE = AND IN(SELECT CFROM CWHERE THACHER=‘周亮’))方法二：SELECT SnFROM SWHERE Sex=‘女’(SELECT *FROM SC,CWHERE = AND = AND =‘周亮’)(5) 方法一：SELECT CFROM CWHERE NOT EXISTS(SELECT *FROM SCWHERE = AND IN（SELECT SFROM SWHERE Sn=‘李清’)）方法二：SELECT CFROM SC,SWHERE = AND = AND =‘李清’(6) 方法一：SELECT DISTINCT FROM SC AS SC1, SC AS SC2WHERE = AND !=方法二：SELECT S FROM SC GROUP BY SHAVING COUNT(*)=2(7) 方法一：SELECT C, CnFROM CWHERE NOT EXISTS(SELECT *FROM SWHERE NOT EXISTS(SELECT *FROM SCWHERE = AND =))方法二：SELECT C, CnFROM CWHERE NOT EXISTS(SELECT *FROM SWHERE S NOT IN(SELECT SFROM SCWHERE =)方法三：SELECT C, CnFROM CWHERE C IN(SELECT CFROM SCGROUP BY CHAVING COUNT(*)=(SELECT COUNT(*)FROM S)(8) 方法一：SELECT DISTINCT SFROM SCWHERE C IN(SELECT CFROM CWHERE TEACHER=‘周亮’)方法二： SELECT DISTINCT SFROM SCWHERE EXISTS(SELECT *FROM CWHERE = AND TEACHER=‘周亮’)方法三： SELECT DISTINCT SFROM SC, CWHERE = AND =‘周亮’(9) SELECT Sn, SaFROM SWHERE =‘男’ AND (SELECT AVG() FROM S AS S1WHERE =‘女’)(10)方法一： SELECT , FROM S,S1WHERE =‘男’ AND ( SELECT Max()FROM S,S2WHERE =‘女’ )方法二： SELECT , FROM S,S1WHERE =‘男’ AND ALL(SELECT FROM S,S2WHERE =‘女’ )(11)方法一： Select Snfrom Swhere (select from S as S1where =39。曹童39。) and ( select from S as S2 where =39。曹童39。)方法二： Select Snfrom S as S1where Exists (select *from S as S2where =39。曹童39。) and and 11 /
醫(yī)療健康相關(guān)推薦
鄂ICP備17016276號-1