Find out how many employees are managed by ‘James Adams’.
What will be an ideal response?
SELECT COUNT(empNo) FROM Employee
WHERE deptNo = (SELECT deptNo FROM Employee WHERE fName = ‘James’ AND
lName = ‘Adams’) AND (fName <> ‘James’ AND lName <> ‘Adams’);
You might also like to view...
Which of the following is NOT a factor to consider when running a delete query?
A) To delete records on the one side of the relationship and the related records on the many side, enable the Referential Integrity and Cascade Delete Related Records properties. B) To delete records only on the one side of the relationship, first delete the relationship, and then delete the data. C) To remove data only on the many side of the relationship, create and run the delete query without changing the relationship. D) To remove data in a many to many relationship, create and run the delete query, delete the relationship, and then delete the data.
Program Evaluation Review Technique (PERT)/Critical Path Method (CPM) and Gantt charts are mutually exclusive techniques.
Answer the following statement true (T) or false (F)