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
- 7952 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 happens if you use a wrong connect identifier?
How to count duplicated values in a column 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 are the set operators union, union all, minus & intersect meant to do?
How to insert a new row into a table in oracle?
How to grant create session privilege to a user in oracle?
How to set a transaction to be read only in oracle?
How to manage transaction isolation level?
how may join possible between (requisition with purchase order)
What is SQL Tuning Advisor in Oracle?
Can we use bind variables in oracle stored procedure?
What happens to the data files if a tablespace is dropped?
How to export data with a field delimiter?
What is set verify off in oracle?
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
