There are three tables :
E : EID,ENAME
D : DID,DNAME
empdept : eid, did
select the employees who doesn't belong to any dep
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 |
Can a primary key contain more than one columns?
when i run my query on yesterday it is fast but today it is slow why?
How to delete a column in an existing table in oracle?
how to we delete a row using varray
how to find find & delete duplicate rows from two different tables?
Explain the use of tables option in exp command.
How to define default values for formal parameters?
What are joins, explain all types of joins?
Explain the use of inctype option in exp command.
How to use "while" statements in oracle?
Differentiate between function and procedure in oracle.
interview questions with answer for cts