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

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

صورة
- - - - -

Set Operators Questions


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

#1 mido_develper

mido_develper

    عضو نشط

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

تاريخ المشاركة 24 February 2009 - 01:49 AM

السلام عليكم ورحمة الله وبركاته

من فضلكم
كنت عاوز مساعدة في حل بعض الامثلة المتعلقة ب Set operators

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



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



3.	Produce a list of jobs for departments 10, 50, and 20, in that order. Display job ID and department ID using set operators.



4.	Create a report that lists the employee IDs and job IDs of those employees who currently have a job title that is the same as their job title when they were initially hired by the company (that is, they changed jobs but have now gone back to doing their original job).


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

تم التعديل بواسطة hanyfreedom, 07 March 2009 - 12:52 AM.
تم تعديل عنوان الموضوع ليدل على مضمونه .


#2 TROYMAN

TROYMAN

    مشترك

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

تاريخ المشاركة 24 February 2009 - 01:29 PM

السلام عليكم...
هذا حل بعض الأسئلة و أما الأسئلة الباقية هي بسيطة و لكن لم استطع فهم الفائدة من السؤال.


الأول
select deptno from dept minus
select deptno from emp where job<>'CLERK'
/


الثاني
select CountryName,CountryId from Countries where CountryId in (select CountryId from Countries minus
select CountryId from Departments)
/




الخامس
select ename,e.deptno,dname 
from emp e full outer join dept d on(e.deptno=d.deptno)


<<اللهم لا علـم لنا إلا ما علّمتنا إنك أنت العليــم الحكيــم>>
<<اللهم علّمنا ما ينفعنا و انفعنا بما علّمتنا و ازدنا علماً>>



Programmer (C#.Net,C++,ASP) & Oracle Developer


#3 mido_develper

mido_develper

    عضو نشط

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

تاريخ المشاركة 28 February 2009 - 11:10 PM

جزاك الله كل خير