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
- 7660 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 |
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is meant by joins? List out the types of joins.
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
What is Database Buffers ?
material view and view disadvantages?
What is the difference between truncate & delete command?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
State the various uses of dbcc command?
What is the oracle implicit cursor?
What is the Extension of Oracle Database? As extension of Access Database is .mdb
What is difference between cartesian join and cross join?
How to convert character types to numeric types?
Oracle General 
