【文章內(nèi)容簡(jiǎn)介】
EXISTS(SELECT * FROM G AS G2 WHERE = AND Like 39。c2339。 )。查詢結(jié)果:5)SQL語(yǔ)句:SELECT , FROM (S INNER JOIN G ON = ) INNER JOIN C ON = WHERE ((()=c11 Or ()=c12 Or ()=c21))GROUP BY , 。查詢結(jié)果:6)SQL語(yǔ)句:SELECT , FROM S INNER JOIN G ON = WHERE ((()=c13))。查詢結(jié)果:7)SQL語(yǔ)句:SELECT , , FROM (S INNER JOIN G ON =) INNER JOIN C ON =WHERE ((() Like 39。s10139。) AND ((Exists (SELECT * FROM G AS G2 WHERE = AND LIKE 39。s10239。))False))。查詢結(jié)果:8)SQL語(yǔ)句:SELECT C.* FROM CWHERE ((() Not In (SELECT FROM G)))。查詢結(jié)果:9)SQL語(yǔ)句:SELECT , Avg() AS GREAT之平均值, Sum() AS GREAT之總計(jì)FROM S INNER JOIN G ON =GROUP BY 。查詢結(jié)果:10)SQL語(yǔ)句:SELECT , , Count() AS GRADE之計(jì)數(shù)FROM S INNER