ممكن حل لهذا السؤال
تاريخ المشاركة 28 September 2006 - 09:38 PM
تاريخ المشاركة 29 September 2006 - 02:58 AM
The HR department needs a query that prompts the user for an employee last name. The query then displays the last name and hire date of any employee in the same department as the employee whose name they supply (excluding that employee). For example, if the user enters Zlotkey, find all employees who work with Zlotkey (excluding Zlotkey).
where department_id=(select department_id