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
- 7589 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what's query optimization and without use of IN AND Exist can we get another way data from query
What exactly do quotation marks around the table name do?
Please explain oracle data types with examples?
What is sequence?
Name the three major set of files on disk that compose a database in Oracle?
Where is the export dump file located?
How do I start tns listener?
What is oracle update statement with inner join ?
What is varray?
How to create an oracle database?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What are the attributes that are found in a cursor?
When do I need to use a semicolon vs a slash in oracle sql?
What is the usage of synonyms?
What is meant by joins?
