题目内容

排序用下面( )个子句。

A. group by
B. order by
C. ASC
D. where

查看答案
更多问题

求平均值用( )个聚合函数。

A. avg( )
B. max( )
C. average( )
D. mean( )

分组查询的关键字是( )

A. order by
B. from
C. group by
D. group

where子句、group by子句、having子句在select语句中的顺序是()

A. having子句、group by子句、where子句
B. group by子句、having子句、where子句
C. group by子句、where子句、having子句
D. where子句、group by子句、having子句

分组查询中,去掉不需要的组用( )关键字。

A. having
B. where
C. group by
D. from

答案查题题库