إنتقال للمحتوى

  • تسجيل الدخول عبر الفيس بوك تسجيل الدخول عبر تويتر Log In with LinkedIn Log In with Google      تسجيل دخول    
  • إنشاء حساب

صورة
- - - - -

ممكن حل لهذا السؤال


1 رد (ردود) على هذا الموضوع

#1 a_m2

a_m2

    مشترك

  • الأعضــاء
  • 169 مشاركة
  • البـلـد: Country Flag

تاريخ المشاركة 28 September 2006 - 09:38 PM

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).

#2 abd_104

abd_104

    عضو

  • الأعضــاء
  • 29 مشاركة

تاريخ المشاركة 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).

عرض المشاركة


[SIZE=7][COLOR=red][B]
select last_name,hire_date
from employees
where department_id=(select department_id
from employees
where last_name='Zlotkey')
ABD ELKADER MOHAMED