在SqlServer的示例数据库NorthWind中,你想获得一张包含lastName和orderDate的列表,,该列表中的雇员至少要处理过一份订单。下面的T-SQL都可以实现该要求,除了


在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

正确答案:A


Tag:SQLServer 雇员 示例 时间:2024-02-07 22:23:25