单选题
下述语句的功能是将两个查询结果合并为一个结果，其中正确的是__________。
A、
select sno,sname, sage from student where sdept = 'cs '
Order by sage
Union
select sno,sname,sage from student where sdept = 'is'
Order by sage
B、
select sno,sname, sage from student where sdept = 'cs '
Union
select sno,sname, sage from student where sdept = 'is '
Order by sage
C、
select sno,sname,sage from student where sdept = 'cs '
Union
select sno,sname from student where sdept = 'is'
Order by sage
D、
select sno,sname,sage from student where sdept = 'cs'
Order by sage
Union
select sno,shame, sage fron student where sdept = 'is'
【正确答案】
B
【答案解析】
提交答案
关闭