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
- 6576 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 an oracle table?
How to get maxsal , minsal, ename department wise in single query
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How many categories of data types?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What is the difference between view and materialized view in Oracle?
How to define a variable of a specific record type?
what is meant by magic query
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What is parameterized cursor in oracle?
What are the uses of synonyms?
In the oracle version 9.3.0.5.0, what does each number shows?
What is a subquery in oracle?
How do we display rows from the table without duplicates?
