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

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

صورة
- - - - -

Report About Set Operatores


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

#1 mido_develper

mido_develper

    عضو نشط

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

تاريخ المشاركة 20 February 2008 - 10:08 PM

[يسار]please i want some one to solve this problem to me

i want to make this reports
"The HR department needs a list of department IDs for departments that do not contain the job ID ST_CLERK. Use set operators to create this report


"The HR department needs a list of countries that have no departments located in them. Display the country ID and the name of the countries. Use set operators to create this report[/يسار]


"The HR department needs a report with the following specifications:
Last name and department ID of all the employees from the EMPLOYEES table, regardless of whether or not they belong to a department
Department ID and department name of all the departments from the DEPARTMENTS table, regardless of whether or not they have employees working in them
Write a compound query to accomplish this

.

#2 mr_khaledali

mr_khaledali

    عضو

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

تاريخ المشاركة 22 February 2008 - 02:59 AM

جواب السؤال الأول
[codebox] select department_id,job_id from employees
minus
select department_id ,job_id from employees where job_id='ST_CLERK';[/codebox]
ORACLE CERTIFIED PROFESSIONAL
ORACLE APPLICATION DEVELOPER

#3 mido_develper

mido_develper

    عضو نشط

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

تاريخ المشاركة 23 February 2008 - 12:16 AM

and what about the second question please