高等继续教育 / 数据库程序设计
正确率:100%
网络远程教育期末考试【数据库程序设计】模拟试题
查询设备大修费用已超过5000的设备。正确的命令是:
考题选项:
sel_ect 编号 from dx group by 编号 where sum(费用)>5000
sel_ect 编号 group by 编号 having sum(费用)>5000
sel_ect 编号 from sb group by 编号 having sum(费用)>5000
sel_ect 编号,sum(费用) from sb having sum(费用)>5000
查询设备大修费用已超过5000的设备。正确的命令是:
考题选项:
sel_ect 编号 from dx group by 编号 where sum(费用)>5000
sel_ect 编号 group by 编号 having sum(费用)>5000
sel_ect 编号 from sb group by 编号 having sum(费用)>5000
sel_ect 编号,sum(费用) from sb having sum(费用)>5000
参考答案:
佳题速递: