11 下列那個 SQL 查詢,可以正確地選出所有住在「人口超過一百萬」的城市 中的員工?


(A) SELECT Name FROM Employee, City WHERE City_Id = Id AND Population > 1000000;
(B)SELECT e.Name FROM Employee e, City c WHERE e.Id = c.Id AND c.Population > 1000000;
(C) SELECT Employee.Name FROM Employee, City WHERE City_Id = Id AND Population > 1000000;
(D)SELECT e.Name FROM Employee e, City c WHERE e.City_Id = c.Id AND c.Population > 1000000;

答案:登入後查看
統計: 尚無統計資料