对于学生信息表（XSB），包含字段：学号（SNO），姓名（SNAME），性别（SEX），年龄（AGE），所在系（DEPT），其中SNO为主码，检索年龄在20~30之间的学生姓名和年龄，正确的语句是（） -题库考试答案搜索网

对于学生信息表（XSB），包含字段：学号（SNO），姓名（SNAME），性别（SEX），年龄（AGE），所在系（DEPT），其中SNO为主码，检索年龄在20~30之间的学生姓名和年龄，正确的语句是（）

单选题

2022-09-21 21:06

A、select sname，age from xsb where age>20and age<23
B、select*from xsb where age between20 and 23
C、select sname，age from xsb where agebetween20 and 23

查看答案

正确答案

C

试题解析

标签：大学试题工学结构化查询语言（SQL）计算机科学技术

感兴趣题目

A salvor may be（）the whole or part of the payment due under Salvage Convention to the extent that the salvage operations have become necessary or more difficult because of fault or neglect on his part or if the salvor has been guilty of fraud or other dishonest conduct.

The （） is used for hauling in or letting out the wires or ropes.

Vessels must be（）valid certificate of nationality or certificated of registry or license.

When loading or discharging dry mud or cement，crew members should use goggles and（）.

Effects which are dutiable or subject to prohibitions or restrictions should be declared in （）.

The（）may examine or re-examine the goods or take samples from them straightaway in the absence of the consignee or the consignor whenever it considers this necessary.

（）are liable to be stoten, pilfered or may damaged due to improper handing or stowage.

Banks have no liability for any delay or loss caused by postal or telex failure.

逻辑运算符（AND、NOT、OR）的运算顺序是AND→OR→NOT。

Demand curve（or demand schedule）需求曲线（或需求表）

●设AND、OR和NOT分别表示按位与、按位或和按位求反运算，且X=10011011，Y=01111010，Z=11101000，则(NOT(X) AND Y)= (9) ， (Y OR NOT(Z))= (10) 。10011011011110101110100001100000(10)

逻辑运算符（AND、NOT、OR）的运算顺序是AND→OR→NOT。

相关题目: boost的意思是:help or encourage to increase or improve; eloquent的意思是:fluent or persuasive in speaking or writing; A campus emergency ______ occur at any time of the day or night, weekend, or holiday, with little or no warning.; Mainly east 3 or 4 partly cloudy to overcast occasional rain（）slowly south moderate or good.; （）any case or suspected case of quarantinable disease，or any case of eruptive disease or any death be discovered，the local quarantine officer must be notified immediately．; Should any case or suspected case of quarantinable disease，or any case of eruptive disease or any death be discovered，the local Quarantine Officer must be（）immediately.; Masters are（）solely responsible for all damages or accidents of whatever kind resulting from the navigating or handling of their vessels by day or by night.; 系统中雷达状态包括Unknown、Operational（or ON）、Failed（or OFF）、Detached。; The carrier is liable for loss of or damage to the goods or delay in delivery caused by fire，（）the claimant proves that the fire arose from fault or neglect on the part of the carrier，his servants or agents.; Shutdown price（or point，or rule）停业价格（或停业点、停业原则）; 在Transact-SQL语句的WHERE子句中，完全可以用IN子查询来代替OR逻辑表达式。; 已知x=10，表达式“x＞10 And x＜=100 Or 10 Mod 2=0"的值为( )。; 信息处理技术员考生信息库中，具有“准考证号”、“姓名”、“笔试成绩”与“机考成绩”等字段。按“笔试成绩＞0 and机考成绩＞0”查询，有r1人；按“笔试成绩＞0 or机考成绩＞0”查询，有r2人，则必然有关系(69)。; 翻译：With Average or With Particular Average（WA or WPA）（）; 设a=′′a′′，b=′′b′′，c=′′c′′，d=′′d′′，执行语句x=IIf（（ad），′′A′′，′′B′′）后，x的值为（　　）。; 已知X=21，Y=15，Z=22，计算表达式（（X>Y）or（Y>Z））and（（X<><>; 有SQL语句： SELECT * FROM 教师 WHERE NOT (工资＞3000 OR 工资＜2000) 与如上语句等价的SQL语句是; （）shall be liable for loss of and damage to the Vessel and／or goods arising or resulting from inaccuracies in stating the description，quantity，weight，measurement or contents.; Every deliberate act of wrongdoing by the master or any of the crew against the ship or cargo，without the authorization or privity of the Shipowner or his agent，is（）.; （）, or drum is used for hauling in or letting out the wires or ropes which will fasten the ship to the shore.

广告位招租WX:84302438

题库考试答案搜索网

免费的网站请分享给朋友吧