你可能感兴趣的试题
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')
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 FROMS,SC
WHERE S.S# S S# AND C#=‘C2’C) 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
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’)
S0.5.S1.S3.S10 S0.5.S1.S5.S10 S1.S3.S5.S10 S0.5.S1.S2.S10
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# FORM SC WHERE C#=‘C2’)
SELECT S.S#,SNAME FROM S WHERE S.S#=(SELECT S S# FROM SC WHERE C#=‘C2’) SELECT S.S#,SNAME FROM S,SCWHERE S.S#=S S#AND C#=‘C2’ SELECT S.S#,SNAME FROM S, SELECT S.S#,SNAME FROM S
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 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'ORDER BY 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# 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# FORM SC WHERE C#=‘C2’)
S与S、S 病理S与S、S S与S、S 病理S与S、S S与S、S
S.(s)>S.(l)>S.(g) S.(l)>S.(s)>S.(g) S.(g)>S.(l)>S.(s) S.(g)>S.(s)>S.(l)
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’’ )