未分类题

听力原文：由题目中的图片可以得出：查询的条件是“数学成绩大于数学平均分”，需要显示的字段是“学号”和“数学”，SQL语句中也应包含这些数据。
下图是使用查询设计器完成的查询，与该查询等价的SQL语句是。
在下图中，与查询设计器的筛选标签中所设置的筛选功能相同的表达式是。
A.成绩表.综合成绩＞=80AND成绩表.综合成绩=＜90
B.成绩表.综合成绩＞80AND成绩表.综合成绩＜90
C.80＜=成绩表.综合成绩＜=90
D.80＜成绩表.综合成绩＜90

A.shangxuebA.cn/images/2010q3/ct_ctabm_ctabchoose_00066(201006).jpg'>
在下图中，与查询设计器的筛选标签中所设置的筛选功能相同的表达式是______。B.shangxuebA.cn/images/2010q3/ct_ctabm_ctabchoose_00067(201006).jpg'>
A.成绩表.综合成绩＞=80AND成绩表.综合成绩=＜90
B.
C.综合成绩＞80AND成绩表.综合成绩＜90
C.
D.综合成绩＜=90
D.

【参考答案】

A
解析：由题目中的图片可以得出：查询条件是“综合成绩在80和90之间，包含80和90”。答案C不符合SQL语......

(↓↓↓ 点击下方‘点击查看答案’看完整答案 ↓↓↓)

<上一题目录下一题>

热门试题

未分类题

There are some social problems in the United States. And drug abuse has come to be 【21】______ as one of the most challenging social problems facing the nation. Indeed, the very word' drug' excites strong emotion, and opinion 【22】______ since the late 1960s have shown that 'drug problem' is 【23】______ by most Americans as a major 【24】______ to the society, particularly to its younger members.Drug abuse is a social problem because it has a wide range of social 【25】______ ,-- some obvious and measurable, some hidden and difficult to quantify. There is strong 【26】______ between some forms of drug use and crimE.The use of alcohol, for example, is highly 【27】______ with violent crimE.Heroin dependence, too, is related to crime, 【28】______ not so directly to violencE.Heroin addicts (those who depend on heroin) may need as 【29】______ as $ 100 a day to support their habit, and most addicts find that they must 【30】______ in order to collect these sums. In 【31】______ , users of illegal drugs have to rely directly or indirectly 【32】______ criminal networks that manufacture, 【33】______ , and distribute these drugs. The profits from these illegal commerce are 【34】______ and the criminal organizations have be come deeply 【35】______ in the supply of heroin and other drugs.Drug dependence does a lot of harm in 【36】______ . of personal health and safety. The 【37】______ user of drugs is much more likely than a member of general population to be killed or to 【38】______ suicide, either deliberately or accidentally. Drug dependence, too, may 【39】______ other areas of individual's life, 【40】______ from the home to the work place to personal relationships with friends.【21】A.regardedB.respectedC.referredD.treated

A.B.
C.
【21】
A.regarded
B.respected
C.referred

未分类题

【39】D.reduce

A.affect
B.weaken
C.impair