There are three tables :
E : EID,ENAME
D : DID,DNAME
empdept : eid, did
select the employees who doesn't belong to any dep
Answer Posted / 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 |
Post New Answer View All Answers
How do we get field detail of a table?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is logical backup in oracle?
Explain oracle left join with an example?
How to load data through external tables?
What do you understand by database schema and what does it hold?
What is sequence?
Can group functions be mixed with non-group selection fields?
What are dml statements in oracle?
How to run create database statement?
Where do you use decode and case statements?
How to assign a tablespace to a users in oracle?
What is oracle database 10g express edition?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
 How to use an oracle sequence generator in a mapping?