There are three tables :
E : EID,ENAME
D : DID,DNAME
empdept : eid, did
select the employees who doesn't belong to any dep
- 4 Answers
- 6229 Views
- Microsoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / neha_gupta
SELECT E.ENAME FROM EMPLOYEE E WHERE E.EID IN (SELECT EID
FROM EMPDEPT WHERE DID IS NULL)
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / sudipta santra
select e.ename from e where e.eid in (
(select e.eid from e
minus
select eid from empdept,d where d.did=empdept.did))
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nathan
SELECT ename
FROM emp
WHERE NOT EXISTS (SELECT NULL
FROM dept
WHERE dept.deptno = emp.deptno);
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ajit
select e.eid, e.ename
from E e, D d
where e.eid = d.did(+)
and d.did is null;
| Is This Answer Correct ? | 0 Yes | 0 No |
how to retrieve data from different tables ,place this data in different excel worksheets.
If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?
what is the dual table in oracle?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is a SNAPSHOT ?
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
What is Network Database link ?
What is the exact use of Collections?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
How to add a new column to an existing table in oracle?
waht is referencial integrity?
Why does oracle 9i treat an empty string as null?
Oracle General 
