Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
- returns all employees with all departments they have a contract with
SELECT e.empID, e.name, e.uid, d.depID, d.depname, d.locaton from employees e LEFT JOIN contracts c ON c.empID=e.empID LEFT JOIN departments d ON d.depID=c.depID
- without returning Karen, since she has contract with only one dep, and Peter who has only one contract with one dep
SELECT e.empID, e.name, e.uid, d.depID, d.depname, d.locaton, COUNT(DISTINCT something) from employees e LEFT JOIN contracts c ON c.empID=e.empID LEFT JOIN departments d ON d.depID=c.depID GROUP BY something HAVING the group by > 1
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.