【单选题】【消耗次数: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语句中,使用*表示( )。
①  选择任何属性
②  选择全部属性
③  选择全部元组
④  选择主码
随机题目
【单选题】 You’re ____ your time trying to persuade him. He’ll never join us. ?
①  spending ?
②  wasting ?
③  losing ?
④  missing?
【单选题】 The boy lost his ____when he stepped on the icy road.
①  way
②  weight
③  balance
④  direction
【单选题】 Never in my life ____ or seen such a thing.
①  I have heard of
②  I had heard of
③  have I heard of
④  did I hear of
【单选题】 —I’m sorry to keep you waiting. —Oh, not at all. I___ here only a few minutes.
①  have been
②  had been
③  was
④  will be
【单选题】 The bus is late and Julie is cold. She____ for the bus for 10 minutes.
①  waits
②  waited
③  has been waiting
④  has waited
【单选题】 Put it down, Richard. You mustnt read ____ letter.
①  anyones elses
②  anyones else
③  anyone elses
④  anyone else
【单选题】 ____ the English examination, I would have gone to the concert last Sunday.
①  In spite of
②  But for
③  Because of
④  As for
【单选题】 Every society has its own peculiar customs and____ of acting.
①  attitudes
②  behavior
③  ways
④  means
【单选题】 “She is from Shanghai, ____ population is larger than that of any other city inChina.”
①  its
②  which
③  whose
④  that
【单选题】 Mary: How do you like Professor White’s lecture? John: ____
①  He talked about economy.
②  He teaches Class 2 students.
③  Very much.
④  He is a middle-aged professor.