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
- 13892 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
Are left and right joins the same?
What is embedded sql with example?
Why do we use sql constraints?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
Explain select statements in sql?
What are the 3 types of behavioral triggers?
How to take user input in pl sql?
What does pl sql stand for?
Can we create view in stored procedure?
What do you mean by table in sql?
What is the difference between sql and mysql?
Where is pl sql used?
How do I audit the sql sent to the server?
What is the order of sql select?
What are the benefits of stored procedures?
