【单选题】【消耗次数:1】
在SELECT语句的ORDER BY子句中,若需要按照指定列的升序排列表,则使用的保留字是( )。
DESC
ASC
ABC
DEC
参考答案:
复制
纠错
相关题目
【单选题】 在SELECT语句的ORDER BY子句中,若需要按照指定列的升序拍列表,则使用的保留字是( )。
①  DESC
②  ASC
③  ABC
④  DEC
【单选题】 在SELECT语句的WHERE子句中,与所使用的保留字ANY等效的是( )。
①  SOME
②  ALL
③  IN
④  LIKE
【单选题】 SELECT语句中的( )子句只能配合GROUP BY子句使用。
①  ORDER BY
②  INTO
③  HAVING
④  COMPUTE
【单选题】 在SELECT语句的WHERE子句中,当需要判断一个子查询的结果是否为空时,则在专门比较式中使用的保留字为( )。
①  ALL
②  EXISTS
③  BETWEEN
④  LIKE
【单选题】 SELECT语句中使用distinct子句表示查询结果中( )。
①  属性名都不相同
②  去掉重复的列
③  去掉重复的行
④  属性值都不相同
【单选题】 SELECT语句中使用distinct子句表示查询结果中( )。
①  A.属性名都不相同
②  B.去掉重复的列
③  C.去掉重复的行
④  D.属性值都不相同
【单选题】 作为语句标号使用的C保留字case和default只能用于( )语句中。
①  if
②  for
③  switch
④  while
【单选题】 作为语句标号使用的C保留字case和default只能用于( )语句中。
①  if
②  for
③  switch
④  while
【判断题】 执行命令“select * from sb order by 价格 DESC,启用日期 asc”,将查询表中所有设备的基本情况,查询结果按价格降序排,价格相同再按启用日期升序排
①  正确
②  错误
【单选题】 在SELECT语句中,使用*表示( )。
①  选择任何属性
②  选择全部属性
③  选择全部元组
④  选择主码
随机题目
【单选题】 We are going to have a singing party tonight. Would you like to join us?___________
①  I’m afraid not, because I have to go to an important meeting.
②  Of course not. I have no idea.
③  No, I can’t.
④  That’s all set.
【单选题】 Use daily writing to ______ your communication skills.
①  track
②  discharge
③  contract
④  enhance
【单选题】 The dean of the Philosophy Department requested that the visiting scholar ______ a lecture on the philosopher Sartre.
①  gave
②  give
③  would give
④  had given
【单选题】 It became harder for women married to diplomats(外交家) to _______ their own interests.
①  pursue
②  replace
③  absorb
④  convince
【单选题】 As a result of his hard work, he has gained ______ to the Beijing University.
①  access
②  commitment
③  opportunity
④  reward
【单选题】 Planning so far ahead _____ no sense -- so many things will have changed by next year.
①  made
②  is making
③  makes
④  has made
【单选题】 How can you keep the machine ()when you are away?
①  run
②  to run
③  running
④  being run
【单选题】 I hate people who ____ the end of a film that you haven’t seen before.
①  reveal
②  rewrite
③  revise
④  reverse
【单选题】 Since the matter was extremely _____, we dealt with it immediately.
①  tough
②  tense
③  urgent
④  instant
【单选题】 As to who is to be hired, it is the Human Resources Department()has the final say.
①  whose
②  those
③  these
④  that