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?
Answers were Sorted based on User's Feedback
Answer / sayalibsl
select e2.empno, e2.ename from A e1, B e2
where e1.empno!=e2.empno;
Is This Answer Correct ? | 15 Yes | 5 No |
Answer / bijaylaxmi
select b.empno,b.ename from b where not exists(select * from a
where a.empno=b.empno)
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / baji
select * from a full outer join b on a.empno=b.empno
minus
select * from a inner join b on a. empno=b.empno;
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / arun
select *from B where (empno,ename) not in (Select
empno,ename from A)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rajesh venati
select b.empno as empno, b.ename as ename from a, b where
a.empno!=b.empno;
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / shrawan kumar keshri
select * from A
except
select * from B
Is This Answer Correct ? | 1 Yes | 3 No |
What is server name sql?
What is record type in pl sql?
Are dml statements autocommit?
explain advantages of innodb over myisam. : Sql dba
Is hadoop a nosql?
Can we connect to postgresql using sql developer?
How do I debug a stored procedure?
What is the diffrence between IN and EXISTS.which one is faster.
Is it possible to sort a column using a column alias?
Can I create table without primary key?
How do u count no of rows in a table?
What are the different types of constraints?