【单选题】【消耗次数:1】
在SQL的语句中,对输出结果排序的语句是( )。
GROUP BY
WHERE
ORDER BY
HAVING
参考答案:
复制
纠错
相关题目
【单选题】 在SQL的语句中,对输出结果排序的语句是( )。
①  GROUP BY
②  ORDER BY
③  WHERE
④  HAVING
【判断题】 SELECT语句中的条件可以用WHERE或HAVING引出,但HAVING必须在GROUP BY之后使用。
①  正确
②  错误
【单选题】 对由 SELECT—FROM—WHERE—GROUP—ORDER 组成的 SQL 语句,其在被 DBMS 处理时,各子句的执序次序为( )。
①  A.SELECT—FROM—GROUP—WHERE—ORDER
②  B.FROM—SELECT—WHERE—GROUP—ORDER
③  C.FROM—WHERE—GROUP—SELECT—ORDER
④  D.SELECT—FROM—WHERE—GROUP—ORDER
【单选题】 在SQL的查询语句中,group by选项实现的功能是(  )。
①  选择
②  求和
③  排序
④  分组统计
【单选题】 在SQL的查询语句中,order by选项实现的功能是( )。
①  投影
②  求和
③  排序
④  分组统计
【单选题】 在SQL语句中,用于创建基本表的语句是( )。
①  CREATE SCHEMA
②  CREATE TABLE
③  CREATE VIEW
④  CREATE DATABASE
【单选题】 在SQL语句中,用于更新表数据的语句是( )。
①  ALTER
②  SELECT
③  UPDATE
④  INSERT
【判断题】 SELECT语句中的条件可以用WHERE或HAVING引出,但HAVING必须在GROUPBY之后使用。
①  正确
②  错误
【单选题】 下列条件语句中输出结果与其他语句不同的是。
①  if(a==0)printf(“%d\n”,y);else printf(“%d\n”,x);
②  if(a)printf(“%d\n”,x); else printf(“%d\n”,y);
③  if(a==0)printf(“%d\n”,x);else printf(“%d\n”,y);
④  if(a!=0)printf(“%d\n”,x);elseprintf(“%d\n”,y);
【单选题】 下列条件语句中输出结果与其他语句不同的是。
①  if(a)printf(“%d\n”,x); else printf(“%d\n”,y);
②  if(a==0)printf(“%d\n”,y);else printf(“%d\n”,x);
③  if(a!=0)printf(“%d\n”,x);elseprintf(“%d\n”,y);
④  if(a==0)printf(“%d\n”,x);else printf(“%d\n”,y);
随机题目
【单选题】 I’m very sorry to have ____ you with so many questions on such an occasion.
①  interfered
②  offended
③  impressed
④  bothered
【单选题】 If we say some food is ____, we mean it is safe to eat.
①  ideal
②  editable
③  ideate
④  edible
【单选题】 Most people came to realize that it was about time the government ____ further measures to control the population.
①  must take
②  is taking
③  takes
④  took
【单选题】 He always has a lot of _______ ideas in his mind , and sometimes we do not even know what he is thinking about.
①  novel
②  spoil
③  acceptable
④  additional
【单选题】 Her skin was dry after ____ to the wind during the trip.
①  failure
②  disclosure
③  exposure
④  pressure
【单选题】 Though ____ in a big city, Peter always prefers to paint the primitive scenes of country life.
①  grown
②  raised
③  tended
④  cultivated
【单选题】 The medicine is on sale everywhere. You can get it at ______ chemist’s.
①  each
②  some
③  certain
④  any
【单选题】 The computer has brought about surprising technological changes ____ we organize and produce information.
①  in a way
②  in the way
③  in that way
④  in no way
【单选题】 When Mr. Jones gets old, he will ____ his business to his son.
①  take over
②  hand over
③  think over
④  get over
【单选题】 The ____ of Liberty was dedicated on an island in Upper New York Bay in 1886.
①  Status
②  Statue
③  Stature
④  State