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
- 7813 Views
- Microsoft, I also Faced
- E-Mail Answers
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 to increment dates by 1 in oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is the difference between substr & instr functions?
What is the recommended interval at which to run statspack snapshots, and why?
How can I introduce multiple conditions in like operator?
Will you be able to store pictures in the database?explain.
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
Where do we use decode and case statements?
How to turn on or off recycle bin for the instance?
In oracle there is column command, how will you explain that?
What to do if the startbd.bat failed to start the xe instance?
How to empty your oracle recycle bin?
How do I spool in oracle?
What are privileges and grants?
Write a syntax for update query in oracle?
