题目内容

拼接2个以上select语句查询结果集,用以下( )个语句。

A. order by
B. union
C. join
D. from

查看答案
更多问题

排序用下面( )个子句。

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子句

答案查题题库