Crowdly
Додати до Chrome
Schéma relationnel : Employee ( EmployeeID , FirstName, LastName, Email, Phone...
✅ Перевірена відповідь на це питання доступна нижче. Наші рішення, перевірені спільнотою, допомагають краще зрозуміти матеріал.
Schéma relationnel :
- 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)
Explication des relations :
- 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)
QUESTION
Quelle requête sélectionne les employés dont le salaire est supérieur à tous les employés du département 2 ?A) SELECT * FROM Employee WHERE Salary > ALL (SELECT Salary FROM Employee WHERE DepartmentID = 2);B) SELECT * FROM Employee WHERE Salary > (SELECT Salary FROM Employee WHERE DepartmentID = 2);C) SELECT * FROM Employee WHERE Salary > ANY (SELECT Salary FROM Employee WHERE DepartmentID = 2);D) SELECT * FROM Employee WHERE Salary IN (SELECT Salary FROM Employee WHERE DepartmentID = 2);
❌
✅
❌
❌