1.  >>  河南成教 / SQL Server数据库程序设计
 河南成教 / SQL Server数据库程序设计
正确率:100%

1[单选题]
执行Sql语句:select score*0.5 20 as 加权成绩 from grade where (score*0.5 20)<60 order by score*0.5 20,以下()描述是正确的。


A.错误提示:where 子句中不能出现表达式。

B.错误提示:order by 子句中不能出现表达式

C.正确执行,显示grade表中各列值,按照score由低到高排序。

D.正确执行,显示grade表中各列值,以及加权成绩列,按照score由低到高排序。


 参考答案:
 佳题速递:
  • 中国共产党领导的革命,包括新民主主义革命和社会主义革命两个阶段。 中国近现代史纲要
  • 1[阅读题]  Alfred Nobel, the great Swedish inventor and industrialist, was born in Stockholm on October 21, 1833, but moved to Russia with his parents in 1842, where his father, Immanuel, made a strong position for himself in the engineering industry. Immanuel Nobel invented landmine and made a lot of money from the government during the Crimean War, but went bankrupt soon after. Then, the family returned to Sweden in 1859, where Alfred began his own study of explosives in his father’s lab. He had never been to school or university but had taught himself, and by the time he was twenty, he became a skillful chemist and excellent linguist, speaking Swedish, Russian, German, French and English. He built up over 80 companies in 20 different countries. He was always searching for a meaning to life. He spent much time and money working on how to end the wars, and the peace between nations, until his death in Italy in 1896. His famous last will, in which he left money to provide prizes for outstanding work in physics, chemistry, physiology, medicine, literature and peace, is a memorial to his interests and ideas. And so, the man is remembered and respected long after his death.61. Where was Alfred Nobel born? He was born in _____.A. Sweden                                   B. StockholmC. Russia                                     D. Moscow62. What did Immanuel Nobel invented during the Crimean War?A. The engineering industry.                   B. A strong position.C. Landmine.                                D. Study of explosives.63. Why did Alfred Nobel return to Sweden ? Because his father ______.A. went bankrupt                             B. was put in prison  C. was ill                                    D. died64. How many companies did Alfred Nobel build up? He built up _______ companies in different countries.A. 20                                         B. 40C. 60                                       D. 8065. What was Alfred Nobel always searing for? ______.A. More time and more money                 B. A meaning to life  C. How to end the war                        D. The peace between nations 英语1
  • .纳米材料有哪些力学性能,选择一项:强度塑性弹性模量韧性新材料与现代生活
  • ‌国内生产总值表示一定时期内的某一国家或地区经济( )的市场价值 西方经济学
  • 图5所示卧式加工中心的自动换刀装置采用的是( )刀库。 图5链式 直线式 鼓轮式 格子箱式数控机床
  • 1979年4⽉,党中央召开⼯作会议,( )不属于新“⼋字⽅针”。 党史