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
- 7823 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 |
What the is the diff between local index and global index. give some example.
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
What is object data modeling?
Explain the use of full option in exp command.
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
What are the ansi data types supported in oracle?
Does oracle database need java?
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
How to sort the query output in oracle?
How to get last row id?
How to count groups returned with the group by clause in oracle?
Oracle General 
