题目内容

在学生表STUD中，查询既不是信息系’IS’、数学系’MA’，也不是计算机系’CS’的学生的姓名 (XM)和性别(XB)。SD为系名。实现该功能的正确SQL语句是( )。

A. SELECT XM,XB
B. FROM STUD
C. WHERE SD IN (’IS’,’MA’,’CS’);
D. SELECT XM,XB
E. FROM STUD
F. WHERE SDNOTIN (’IS’,’MA’,’CS’);
G. SELECT XM,XB
H. FROM STUD
I. WHERE SD NOT (’IS’,’MA’,’CS’);
J. SELECT XM,XB
K. FROM STUD
L. WHERE SD NOT IN (IS,MA,CS);

查看答案

搜索结果不匹配？点我反馈

更多问题

We hope that by observing the following points you will enjoy your visit to Christ Church without disturbing the life of the college.* Please obey all notices and do not enter the areas marked Private.* Please do not enter any college rooms.* Please avoid leaving litter (杂物) ; picnicking within the college is not permitted.* Please do not smoke.* Please do not gather so as to obstruct (阻塞) paths or passages, particularly in the Hall.* Please be as quiet as possible, remembering that this is a college where people are working.* In the event of a fire or other danger, or if you hear a fire alarm or warning, please leave the building without delay. At all times please follow the advice of the Custodians (保安人员) who are here to help you.* Closed circuit television surveillance (监视) is in operation. Images are being recorded for purposes of crime prevention and public safety.* Thank you for visiting Christ Church. If you have any comments please write to:The Steward, Christ Church, Oxford OX1 1DP Why is closed circuit television surveillance in operationTo _____________________and ensure public safety.

A— checking account(s)B— interest rateC— deposit accountD— bookkeepingE— personal identification numberF— service chargeG— foreign currencyH— electronic bankingI— bankbookJ— savings bankK— checkbookL— deposit slipM— bank accountN— current accountO— personal loanP— minimum balanceQ—savings account(s)R— automatic teller machineExample: (K) 支票薄QUESTIONS：51．（）个人贷款（）储蓄银行52．（）自动取款机（）银行存折53．（）定期储蓄帐户（）存款单54．（）服务费（）利率55．（）最低余额（）电子银行业务

An engineer is needed by the company to manage the work of installation teams, and to provide engineering assistance when problems occur.

We hope that by observing the following points you will enjoy your visit to Christ Church without disturbing the life of the college.* Please obey all notices and do not enter the areas marked Private.* Please do not enter any college rooms.* Please avoid leaving litter (杂物) ; picnicking within the college is not permitted.* Please do not smoke.* Please do not gather so as to obstruct (阻塞) paths or passages, particularly in the Hall.* Please be as quiet as possible, remembering that this is a college where people are working.* In the event of a fire or other danger, or if you hear a fire alarm or warning, please leave the building without delay. At all times please follow the advice of the Custodians (保安人员) who are here to help you.* Closed circuit television surveillance (监视) is in operation. Images are being recorded for purposes of crime prevention and public safety.* Thank you for visiting Christ Church. If you have any comments please write to:The Steward, Christ Church, Oxford OX1 1DP What should tourists do in the event of a fire or any other dangerThey should leave the building and ______________of the Custodians.