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
- 7647 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is set verify off in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What are the system predefined user roles?
Can group functions be mixed with non-group selection fields?
How to create an oracle testing table?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How many anonymous blocks can be defined?
Explain oracle instance.
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Is oracle an operator?
What privilege is needed for a user to create indexes in oracle?
definition of cluster and non-clustered index?
What is the dynamic sql in oracle?
Is there a function to split a string in plsql?
