Questions Bank | Page 140791

Employee (EmployeeID, FirstName, LastName, Email, Phone, HireDate, Salary, #DepartmentID)
Department (DepartmentID, DepartmentName, #ManagerID)
Project (ProjectID, ProjectName, StartDate, EndDate, Budget)
Employee_Project (#EmployeeID, #ProjectID, Role, AssignmentDate)

Employee (EmployeeID) est la clé primaire.
Department (DepartmentID) est la clé primaire.
Project (ProjectID) est la clé primaire.
Employee_Project (#EmployeeID, #ProjectID) est une clé primaire composite (relation plusieurs-à-plusieurs entre Employee et Project).
Employee(#DepartmentID) → Department(DepartmentID) : Un employé appartient à un département.
Department(#ManagerID) → Employee(EmployeeID) : Un manager est un employé.
Employee_Project(#EmployeeID) → Employee(EmployeeID)
Employee_Project(#ProjectID) → Project(ProjectID)

Quelle requête sélectionne les employés dont le salaire est supérieur à au moins un employé du département 2 ?

A) SELECT * FROM Employee WHERE Salary > ANY (SELECT Salary FROM Employee WHERE DepartmentID = 2);

B) SELECT * FROM Employee WHERE Salary > (SELECT MAX(Salary) FROM Employee WHERE DepartmentID = 2);

C) SELECT * FROM Employee WHERE Salary = ALL (SELECT Salary FROM Employee WHERE DepartmentID = 2);

D) SELECT * FROM Employee WHERE Salary < (SELECT Salary FROM Employee WHERE DepartmentID = 2);

View this question

Crowdly