你可能感兴趣的试题
Where Where’s Where’re Where are
SELECT SNAME,AGE FROM S WHERE S.S#=(SELECT S S#FROM SC WHERE C#='C1') SELECT SNAME,AGE FROM S,SC WHERE S.S#=S S# AND S C#='C1' SELECT SNAME,AGE FROM S,SC WHERE S.S#=S S# AND S C#='C1' ORDERBY S.S# SELECT SNAME,AGE FROM S WHERE
SELECT S.S#,SNAME FROM S WHERE S.S# =(SELECT SC.S#FROM SC WHERE C#='C2') SELECT S.S#,SNAME FROM S,SC WHERE S.S#=SC.S# AND C#='C2' SELECT S.S#,SNAME FROM S,SC WHERE S.S#=SC.S# AND C#='C2' ORDER BY S.S# SELEC S.S#,SNAME FROM S WHERE S.S# IN(SELECT SC.S# FROM SC WHERE C#='C2')
SEIECT SNAME, ADE FROM S WHERE S#=(SELECT S S# FROM SC WHERE C#='MATHS') SELECT SNAME, AGE FROM S WHERE S#=(SELECT S S# FROM SC WHERE S C#='MATHS') SELECT SNAME, AGE FROM S, SC WHERE S#=SS# AND S C#='MATHS' ORDER BY S# SELECT SNAME, AGE FROMS, SC WHERE S#=SS# AND SC#='MATHS'
SELECT S.S#,SNAME FROM S WHERE S.S#
=(SELECT SC.S# FROM SC WHERE C#='C2') SELECT S.S#,SNAME FROM S,SC
WHERE S.S#==SC.S# AND C#='C2' SELECT S.S#,SNAME FROM S,SC
WHERE S.S#=SC.S# AND C#='C2' ORDER BY S.S# SELECT S.S#,SNAME FROM S WHERE S.S
IN (SELECT SC.S## FROM SC WHERE C#='C2')
Where is; It’s Where are;They’re Where’s;They’re Where are;It’s
SELECT S#,SNAME FROM S WHERE S# =(SELECT SS# FROM SC WHERE C#='C2') SELECT S#,SNAME FROM S,SC WHERE S#==SS# AND C#='C2' SELECT S#,SNAME FROM S,SC WHERE S#=SS# AND C#='C2' ORDER BY S# SELECT S#,SNAME FROM S WHERE S IN (SELECT SS## FROM SC WHERE C#='C2')
SELECT S.S#,SNAME FROM S WHERE S.S# =(SELECT SC.S# FROM SC WHERE C#='C2') SELECT S.S#,SNAME FROM S,SC WHERE S.S#==SC.S# AND C#='C2' SELECT S.S#,SNAME FROM S,SC WHERE S.S#=SC.S# AND C#='C2' ORDER BY S.S# SELECT S.S#,SNAME FROM S WHERE S.S IN (SELECT SC.S## FROM SC WHERE C#='C2')
SELECT S.S#,SNAME FROM S WHERE S.S#
=(SELECT SC.S# FROM SC WHERE C#='C2') SELECT S.S#,SNAME FROM S,SC
WHERE S.S#=SC.S# AND C#='C2' SELECT S.S#,SNAME FROM S,SC
WHERE S.S#=SC.S# AND C#='C2' ORDER BY S.S# SELECT S.S#,SNAME FROM S WHERE S.S
IN (SELECT SC.S# FROM SC WHERE C ='C2')
SELECT 学号,姓名,性别 FROM S WHERE EXISTS (SELECT * FROM SC WHERE S学号=学号 AND 成绩<=85) SELECT 学号,姓名,性别 FROMS WHERE NOT EXISTS (SELECT * FROM SC WHERE S学号=学号 AND 成绩<=85) SELECT 学号,姓名,性别 FROMS WHERE EXISTS (SELECT * FROM SC WHERE S学号=学号 AND 成绩>85) SELECT 学号,姓名,性别 FROM S WHERE NOT EXISTS (SELECT * FROM SC WHERE S学号=学号AND成绩<85)
SELECT S#,SNAME FROM S WHERE S# =(SELECT SS# FROM SC WHERE C#='C2') SELECT S#,SNAME FROM SC WHERE S#=SS# AND C#='C2' SELECT S#,SNAME FROM SC WHERE S#=SS# AND C#='C2'ORDER BY S# SELECT S#,SNAME FROM S WHERE S# IN(SELECT SS#FROM SC WHERE C#='C2')
SELECT S.S#,SNAME FROM S WHERE S.S#
=(SELECT SC.S# FROM SC WHERE C#='C2') SELECT S.S#,SNAME FROM S.SC
WHERE S.S#=SC.S# AND C#='C2' SELECT S.S#,SNAME FROM S.SC
WHERE S.S#=SC.S# AND C#='C2'ORDER BY S.S# SELECT S.S#,SNAME FROM S WHERE S.S#
IN(SELECT SC.S#FROM SC WHERE C#='C2')
SELECT S#,SNAME FROM S WHERE S# (SELECT S S# FROM SC WHERE C#='C2') SELECT S#,SNAME FROMS,SC WHERE S#=SS# AND C#='C2' SELECT S#,SNAME FROM S,SC WHERE S=SS# AND C#='C2'ORDER BY S#. SELECTS#,SNAME FROM S WHERE S# IN(SELECT S S# FROM SC WHERE C#='C2')
Where Where’s What’s Where are
SELECT SNAME,AGE FROM S WHERE S.S#=(SELECT SC.S#FROM SC WHERE C.C#='MATHS') SELECT SNAME,AGEFROM SWHERE S.S#=(SELECT SC.S#FROM SC WHERE SC.C#='MATHS') SELECT SNAME,AGE FROM S, SC WHERE S.S#=SC.S# AND SC.C#='MATHS' ORDER BY S.S# SELECT SNAME,AGE FROM S, SC WHERE S.S#=SC.S# AND SC.C#='MATHS'
SELECT S#,SNAME FROM S WHERE S# =(SELECT SS# FROM SC WHERE C#='C2') SELECT S#,SNAME FROM S,SC WHERE S#=SS# AND C#='C2' SELECT S#,SNAME FROM S,SC WHERE S#=SS# AND C#='C2' ORDER BY S# SELECT S#,SNAME FROM S WHERE S IN (SELECT SS# FROM SC WHERE C ='C2')
SELECT*FROM R,S WHERE R.C=S.C SELECT A,B,D FROM R,S WHERE R.C=S.C SELECT A,B,D FROM R,S WHERE R=S SELECT A,B FROM R WHERE(SELECT D FROM S WHERE R.C=S.
SELECT姓名FROM S WHERE EXISTS(SELECT*FROM SC WHERE学号=S.学号AND课程号=’C2’) SELECT姓名FROM S WHERE学号IN(SELECT学号FROM SC WHERE课程号=’C2’) SELECT姓名FROM S JOIN SC ON S.学号=SC.学号WHERE课程号=’C2’ SELECT姓名FROM S WHERE学号=(SELECT学号FROM SC WHERE课程号=’C2’)
when there where there where
SELECT S#,SNAME FROM S WHERE AGE>18 SELECT S#,SNAME FROM S WHERE AGE>=18 SELECT S#,SNAME FROM S WHERE AGE>'18' SELECT S#,SNAME FROM S WHERE AGE>='18'