你可能感兴趣的试题
SELECT S#FROM SC WHERE C#="C2" AND Grade IN (SELECT Grade FROM SC WHERE C#="C2") SELECT S# FROM SC WHERE C#="C2" AND Grade＞= (SELECT Grade FROM SC WHERE C#="C2") SELECT S# FROM SC WHERE C#="C2" AND Grade＞=ALL (SELECT Grade FROM SC WHERE C#="C2") SELECT S# FROM SC WHERE C#="C2" AND Gtade NOT IN (SELECT Grade FROM SC WHERE C#="C2")
sell; taste well sell; are tasted good are sold; are tasted well are sold; taste good
shoe store fruit shop clothes store food shop
all kinds of measures have taken they have taken all kinds of measures it is said that they have taken all kinds of measures I think they have taken all kinds of measures
SELECT 学号,姓名 FROM S WHERE NOT EXISTS; (SELECT * FROM SC WHERE SC.学号=S.学号 AND 成绩<85) SELECT 学号,姓名 FROM S WHERE NOT EXISTS; (SELECT * FROM SC WHERE SC.学号=S.学号 AND 成绩>=85) SELECT 学号,姓名 FROM S,SC; WHERE S.学号=SC.学号 AND 成绩>=85 SELECT 学号,姓名 FROM S,SC; WHERE S.学号=SC.学号 AND ALL 成绩>=85
both; the other all; the others either; another neither; another
ask; for spend; on choose; from share; with
SELECT S# FORM SC WHERE C#="C2"AND GRADE＞=(SELECT GRADE FORM SC WHERE C#="C2") SELECT S# FORM SC WHERE C#="C2"AND GRADE IN(SELECT GRADE FORM S WHERE C#="C2" SELECT S# FORM SC WHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM SC WHERE C#="C2") SELECT S# FORM SC WHERE C#="C2"AND GRADE＞=ALL(SELECT GRADE FORM SC WHERE C#="C2")
SELECT S# FROM SC WHERE C#="C2" AND GRADE＞ =(SELECT GRADE FROM SC WHERE C#="C2") SELECT S# FROM SC WHERE C#="C2" AND GRADE IN(SELECT GRADE FROM SC WHERE C#="C2") SELECT S# FROM SC WHERE C#="C2" AND GRADE NOT IN(SELECT GRADE FROM SC WHERE C#="C2") SELECT S# FROM SC WHERE C#="C2" AND GRADE＞ =ALL(SELECT GRADE FROM SC WHERE C#="C2")
SELECT 学号，姓名 FROM S WHERE NOT EXISTS； (SELECT * FROM SC WHERE SC 学号=S.学号 AND 成绩＜85) SELECT 学号，姓名 FROM S WHERE NOT EXISTS； (SELECT * FROM SC WHERE SC.学号=S.学号 AND 成绩＞=85) SELECT 学号，姓名 FROM S，SC WHERE S.学号=SC.学号 AND 成绩＞=85 SELECT 学号，姓名 FROM S，SC WHERE S.学号=SC.学号 AND ALL 成绩＞=85
SELECT S# FROM SC WHERE C# = "C2" AND Grade IN SELECT Grade FROM SC WHERE C# = "C2") SELECT S# FROM SC WHERE C# = "C2" AND Grade ＞= SELECT Grade FROM SC WHERE C# = "C2") SELECT S# FROM SC WHERE C# = "C2" AND Grade ＞= ALL SELECT Grade FROM SC WHERE C# = "C2") SELECT S# FROM SC WHERE C# = "C2" AND Grade NOT IN SELECT Grade FROM SC WHERE C# = "C2")
However Whatever Whichever Whenever
fruit shop clothes store shoe store book shop
both; the other all; the others either; another neither; another
However Whatever Whichever Whenever
is open is opened is close is closed
all kinds of measures have taken they have taken all kinds of measures it is said that they have taken all kinds of measures I think they have taken all kinds of measures
fruit shop clothes store shoe store book shop
SELECT 学号,姓名 FROM S WHERE NOT EXISTS; (SELECT * FROM SC WHERE SC.学号=S.学号 AND 成绩<85) SELECT 学号,姓名 FROM S WHERE NOT EXISTS; (SELECT * FROM SC WHERE SC.学号=S.学号 AND 成绩>=85) SELECT 学号,姓名 FROM S,SC; WHERE S.学号=SC.学号 AND 成绩>=85 SELECT 学号,姓名 FROM S,SC; WHERE S.学号=SC.学号 AND ALL 成绩>=85
fruit shop clothes store shoe store book shop
湘公网安备 43130202000226号