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 / 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 the use of triggers in Java program? I mean where do we use triggers in Java programming?
In what script is snap$ created? In what script is the scott/tiger schema created?
How to get a list of all user accounts in the database?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to display row numbers with the records?
How can I get column names from a table in oracle?
Why packages are used in oracle?
What is pragma autonomous transaction in oracle?
How remove data files before opening a database?
What are set operators?
What is a relational database management system?
How can I see all tables in oracle?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
Does facebook use oracle?
Explain constraining triggers.