Interested to Buy Any Domain ? << Click Here >> for more details...
TABLE A TABLE B
EMPNO ENAME EMPNO ENAME
1 A 1 A
2 B 2 B
3 C 3 C
4 D 4 D
5 E 5 E
6 F
7 G
HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?
- 10 Answers
- 13233 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / swastik
SELECT
e2.Empno, e2.Ename
FROM B e2
WHERE e2.Empno NOT IN
(
SELECT e1.Empno
FROM A e1
);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can we implement rollback or commit statement in a trigger?
What is the maximum size of sqlite database?
What is cursor in pl sql?
What happens when a trigger is associated to a view?
How can I delete duplicate rows?
What is constant in pl sql?
What port does sql server use?
Explain autonomous transaction.
What is full join?
Is sql port 1433 encrypted?
Does sql support programming?
What is posting?
What are the features of pl sql?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is the difference between partition and index?
