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?
Answer Posted / b
select * from B
minus
select * from A;
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
Which software is used for pl sql programming?
what is a relationship and what are they? : Sql dba
What is lexical units in pl sql?
What is composite data type in pl sql?
what are date and time functions in mysql? : Sql dba
What is meaning of <> in sql?
Can a table contain multiple foreign key’s?
How to display Row Number with Records in Oracle SQL Plus?
What is java sql driver?
What is a sql instance vs database?
How many clustered indexes can you have?
what is self-join? : Sql dba
What is an example of translating a date into julian format?
What is benefit of creating memory optimized table?
What are the different sql commands?