题目内容

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

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);

查看答案

为用户表删除姓名字段的语句是()

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);

查看答案

查询数据库表中的记录,用( )语句

A. select语句
B. update语句
C. delete语句
D. insert语句

查看答案

下列 SQL 语句select * from student where sno = '05880101'union select * from student where sno = '05880102'与此查询语句等价的选项是( )。

A. select * from student where sno= '05880101' and sno= '05880102'
B. select * from student where sno= '05880101' or sno= '05880102'
C. select * from student where sno= '05880101'
D. select * from student where sno= '05880102'

查看答案

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

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

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

为用户表删除姓名字段的语句是()

查询数据库表中的记录,用( )语句

下列 SQL 语句select * from student where sno = '05880101'union select * from student where sno = '05880102'与此查询语句等价的选项是( )。

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