Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7743 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 |
Define Transaction ?
Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
How to login to the server without an instance?
What are the numeric comparison operations?
What is primefaces used for?
How to retrieve the count of updated rows?
How to convert raw data type into text in oracle? Explain
difference between imlicit cursor and explicit cursor ?
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
What is ADDM Advisor in Oracle?
What would you do with an in-doubt distributed transaction?
Oracle General 
