你可能感兴趣的试题
B2单元格中显示5,C2单元格中显示8 B2和C2单元格中均显示13 B2单元格中显示#VALUE!,C2单元格中显示13 B2单元格中显示13,C2单元格中显示#VALUE!
A小区的C2=50,B小区的C2=45 A小区的C2=50,B小区的C2=35 A小区的C2=40,B小区的C2=45 A小区的C2=35,B小区的C2=50
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')
B2单元格中显示5,C2单元格中显示8 B2和C2单元格中均显示13 B2单元格中显示#VALUE!,C2单元格中显示13 B2单元格中显示13,C2单元格中显示#VALUE!
A32<CR>
B45<CR> A45<CR>
B32<CR> A32B45<CR> A 32B45<CR>
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#,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')
A32<CR>
B45<CR> A45<CR>
B32<CR> A32B45<CR> A 32 B 45<CR>
A32<CR> A45<CR> B45<CR> B32<CR> A32B45<CR> A32B45<CR>
B2单元格中显示5,C2单元格中显示8 B2和C2单元格中均显示13 B2单元格中显示#VALUE!,C2单元格中显示13 B2单元格中显示13,C2单元格中显示#VALUE!
A32<CR>
B45<CR> A45<CR>
B32<CR> A32B45<CR> A 32B45<CR>
A32<CR> B45<CR> A45<CR> B32<CR> A32B45<CR> A 32 B 45<CR>
A32<CR>
B45<CR> A45<CR>
B32<CR> A32B45<CR> A 32 B 45<CR>
A32<CR> A45<CR>
B45<CR> B32<CR> A32B45<CR> A32B45<CR>