下列SQL查询操作的含义是（） SELECT * FROM 学生 WHERE 所在系 IN（’数学系’， ’计算机系’）AND 姓名 LIKE ’张%’ A. 求数学系或计算机系姓“张”的学生的所有信息 B. 将数学系和计算机系姓“张”的学生进行连接 C. 求数学系或计算机系姓“张”的学生的名单 D. 将数学系中姓“张”的学生转入计算机系

暂无答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装上学吧APP，拍照搜题省时又省心！

更多“下列SQL查询操作的含义是（） SELECT * FROM …”相关的问题

第1题

下列SQL语句中，用于修改表结构的是（）

点击查看答案

第2题

下列不属于SQL查询的是（）。

A.联合查询

B.传递查询

C.子查询

D.选择查询

点击查看答案

第3题

下列sql脚本中有几个批？ create database jxgl go use...

下列sql脚本中有几个批？ create database jxgl go use jxgl go create table S ( sno char(9) not null primary key, sname char(8) not null unique, sex char(2) null, age smallint null, sdept varchar(50) null ) create table C ( cno char(4) not null primary key, cname varchar(50) not null unique, cdept varchar(50) null, tname char(8) null ) create table SC ( sno char(9) not null references S(sno), cno char(4) not null, grade real null, constraint pk_SC primary key(sno,cno), constraint fk_SC2 foreign key(cno) references C(cno) ) go use jxgl go insert into s values ('SW103101','cairi','F',20,'30'); insert into s values ('SW103102','chenlin','M',20,'30'); insert into s values ('SW103103','chengkun','F',21,'30'); insert into s values ('SW103104','fanye','F',21,'30'); insert into s values ('SW103105','gujianfang','M',21,'30'); insert into s values ('SW103201','houliang','M',21,'30'); insert into s values ('SW103202','huoyong','M',21,'30'); insert into s values ('SW103203','jijianlong','M',20,'30'); insert into s values ('SW103204','judi','M',20,'30'); insert into s values ('SW103205','liandesheng','F',21,'30'); insert into s values ('SW103206','liujian','M',20,'30'); insert into s values ('SW103207','liuwenxue','M',21,'30'); insert into s values ('NW103101','majitai','F',21,'40'); insert into s values ('NW103102','ouyanhui','F',21,'40'); insert into s values ('NW103103','qixiaorui','F',21,'40'); insert into s values ('NW103104','renyang','F',21,'40'); insert into s values ('NW103105','shijian','M',21,'40'); insert into s values ('NW103106','silin','F',20,'40'); insert into s values ('NW103107','songming','M',21,'40'); insert into s values ('IT102101','sunchenghao','M',21,'10'); insert into s values ('IT102102','wangjunfeng','M',21,'10'); insert into s values ('IT102103','wangming','F',21,'10'); insert into s values ('IT102104','wangqiujing','M',20,'10'); insert into s values ('IT102105','wangyijun','F',20,'10'); insert into s values ('IT102106','wangzhicao','M',20,'10'); insert into s values ('ME102101','wangxi','M',21,'20'); insert into s values ('ME102102','wuqing','M',21,'20'); insert into s values ('ME102103','xiaxirui','M',21,'20'); insert into s values ('ME102104','xuxiang','M',21,'20'); insert into s values ('ME102105','xuyaxiang','F',21,'20'); insert into c values ('C101','english','10','chen') insert into c values ('C102','physic','10','liu') insert into c values ('C201','math','30','wang') insert into c values ('C202','chemistry','10','chen') insert into c values ('C301','network','30','gao') insert into c values ('C302','netsecurity','30','wu') insert into c values ('C303','route','30','xiao') insert into c values ('C304','database','30','wang') insert into c values ('C305','C++','30','wang') insert into c values ('C306','Java','30','huang') insert into c values ('C307','electronic','40','yang') insert into c values ('C308','microelectronic','40','zhang') insert into sc (grade,cno,sno) values (32,'C303','NW103103'); insert into sc (grade,cno,sno) values (58,'C301','NW103103'); insert into sc (grade,cno,sno) values (53,'C304','SW103207'); insert into sc (grade,cno,sno) values (37,'C201','SW103105'); insert into sc (grade,cno,sno) values (54,'C102','SW103103'); insert into sc (grade,cno,sno) values (60,'C308','ME102105'); insert into sc (grade,cno,sno) values (55,'C202','SW103104'); insert into sc (grade,cno,sno) values (62,'C202','NW103104'); insert into sc (grade,cno,sno) values (55,'C303','NW103104'); insert into sc (grade,cno,sno) values (60,'C304','SW103206'); insert into sc (grade,cno,sno) values (54,'C101','SW103105'); insert into sc (grade,cno,sno) values (60,'C101','SW103205'); insert into sc (grade,cno,sno) values (56,'C102','NW103104'); insert into sc (grade,cno,sno) values (61,'C102','NW103105'); insert into sc (grade,cno,sno) values (57,'C304','SW103203'); insert into sc (grade,cno,sno) values (62,'C202','ME102102'); insert into sc (grade,cno,sno) values (86,'C302','NW103105'); insert into sc (grade,cno,sno) values (61,'C201','SW103102'); insert into sc (grade,cno,sno) values (62,'C102','NW103102'); insert into sc (grade,cno,sno) values (59,'C201','SW103104'); insert into sc (grade,cno,sno) values (60,'C101','SW103103'); insert into sc (grade,cno,sno) values (61,'C307','ME102104'); insert into sc (grade,cno,sno) values (61,'C102','SW103104'); insert into sc (grade,cno,sno) values (62,'C102','SW103204'); insert into sc (grade,cno,sno) values (62,'C303','NW103102'); insert into sc (grade,cno,sno) values (62,'C101','NW103107'); insert into sc (grade,cno,sno) values (62,'C102','SW103205'); insert into sc (grade,cno,sno) values (62,'C308','ME102104'); insert into sc (grade,cno,sno) values (62,'C303','NW103107'); insert into sc (grade,cno,sno) values (63,'C301','NW103107');

点击查看答案

第4题

在下列SQL语句中，用来查询的语句是（）。

A、ALTER

B、CREATE

C、DROP

D、SELECT

点击查看答案

第5题

下列SQL命令中，可用于删除表的是(??)

A、DROP

B、CREATE