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 |
Is postgresql a server?
Is oracle sql free?
Write a sql query to get the third highest salary of an employee from employee_table?
How many types of cursors supported in pl/sql?
Explain clause in sql?
where are cookies actually stored on the hard disk? : Sql dba
Does truncate remove indexes?
What problem one might face while writing log information to a data-base table in pl/sql?
How many columns should be in an index?
What are the types of variable use in pl sql?
What is procedure function?
Which function is used to return remainder in a division operator in sql?