河南成教 / SQLserver数据库程序设计
正确率:100%
在SqlServer的示例数据库NorthWind中,你想获得一张包含lastName和
orderDate的列表,,该列表中的雇员至少要处理过一份订单。
下面的T-SQL都可以实现该要求,除了
A.select employees.lastname,orders.orderdate
from employees left join orders
on employees.employeeid=orders.employeeid
B.select employees.lastname,orders.orderdate
from employees join orders
on employees.employeeid=orders.employeeid
C.select employees.lastname,orders.orderdate
from employees inner join orders
on employees.employeeid=orders.employeeid
D.select employees.lastname,orders.orderdate
from employees,orders
where employees.employeeid=orders.employeeid
orderDate的列表,,该列表中的雇员至少要处理过一份订单。
下面的T-SQL都可以实现该要求,除了
from employees left join orders
on employees.employeeid=orders.employeeid
from employees join orders
on employees.employeeid=orders.employeeid
from employees inner join orders
on employees.employeeid=orders.employeeid
from employees,orders
where employees.employeeid=orders.employeeid
参考答案:
佳题速递: