A. SELECT*FROM学生; WHERE 年龄>(SELECT 年龄 FROM学生; WHERE 姓名=“孙静”)
B.SELECT*FROM学生; WHERE 姓名=“孙静”
C. SELECT*FROM 学生: WHERE 年龄>(SELECT 年龄; WHERE 姓名=“孙静”)
D.SELECT*FROM 学生: WHERE 年龄>“孙静”
[单选题]“学生”表中学生号为主索引,若用SQL命令INSERT插入一个记录,下面语句正确的是( )。A.(“002”,“孙静”,“女”,“22”)B.(002,“孙静”,NULL,22)C.(NULL,“孙静”,“女”,“22”)D.(002,孙静,女,22)
[单选题]在第27题表中,若用SQL命令检索所有比“刘勋”年龄大的职工记录,下列语句正确的是______。A.SELECT*FROM职工; WHERE年龄>(SELECT年龄FROM职工; WHERE姓名=“刘勋”)B.SELECT*FROM职工; WHERE姓名=“刘勋”C.SELECT*FROM 职工; WHERE年龄>(SELECT年龄; WHERE姓名=“刘勋”)D.SELECT*FROM职工; WHERE年龄>“刘勋”
[单选题]有学生表:S(学号,姓名,性别,年龄),如果要检索S表中所有比“王华”年龄大的学生姓名、年龄和性别,则SQL语句是( )A.SELECT姓名,年龄,
[单选题]有学生表:S(学号,姓名,性别,年龄),如果要检索S表中所有比“王华”年龄大的学生姓名、年龄和性别,则SQL语句是( )。A.SELECT姓名,年龄,
[单选题]有学生表:S(学号,姓名,性别,年龄),如果要检索S表中所有比“王华”年龄大的学生姓名、年龄和性别,则SQL语句是( )。A.SELECT姓名,年龄,
[单选题]检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SELECT语句是______。A.SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE FROM S WHERE SN='王华')B.SELECT SN,AGE,SEX FROM S WHERE SN='王华'C.SELECT SN,AGE, SEX FROM S WHERE AGE>(SELECT AGE WHERE SN='王华')D.SELECT SN,AGE,SEX FROM S
[单选题]检索所有比“王华”年龄大的学生的姓名、年龄和性别,正确的SELECT语句是______。A.SELECT SN,AGE,SEX FROM S SHERE AGE>(SELECT AGE FROM S WHERE SN='王华')B.SELECT SN,AGE,SEX FROM S WHERE SN='王华'C.SELECT SN,ACE,SEX FROM S WHERE AGE>(SELECT ACE WHERE SN='王华')D.SELECT SN,ACE,SEX FROM S
[单选题]要查询Information表中学生姓中含有“张”的学生情况,可以用下列哪个命令?——A.SELECT* FROM Information WHERE s—Flame=‘张’B.SELECT*FROM Information WI-IERE s—name LIKE‘张%’C.SELECI*FROM Information WHERE s._name LIKE‘张一’D.SEt,ECT*FROM Information WHERE s—name LIKE‘%张%’
[单选题]若用SQL命令检索所有比“刘宁”基本工资多的职工记录,下列语句正确的是 ( )。A. SELECT*FROM zg; WHERE 基本工资>(SELECT基本工资FROM zg; WHERE 姓名=“刘宁”)B.SELECT*FROM zg; WHERE 姓名=“刘宁”C.SELECT*FROM zg; WHERE 基本工资>(SELECT基本工资; WHERE 姓名=“刘宁”)D.SELECT*FROM zg; WHERE 基本工资>“刘宁”
[单选题]查询选修了课程号为“C1”的学生的姓名和年龄,若用下列SQL的SELECT语句表达 时,错误的是( )。A.SELECT SNAME,AGE FROM S WHERE S .S#=(SELECT SC.S# FROM SC WHERE C.C#=’C 1’) B.SELECT SNAME,AGE FROM S,SC WHERE S.S#=SC.S# AND SC.C#=’C 1’ C.SELECT SNAME,AGE FROM S,SC WHERE S.S#=SC.S# AND SC.C#=’C