题目内容

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

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

为用户表添加姓名字段的语句是()

A. alter table user add name varchar(40);
B. alter table user drop name;
C. alter table user rename oldname to newname;
D. alter table user alter name varchar(50);

答案查题题库