select * from B minus select * from A;

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?

Question Posted / b

10 Answers
13603 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / b

select * from B
minus
select * from A;

Is This Answer Correct ?

12 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How show all rows in sql?

1014

Is there a way to automate sql execution from the command-line, batch job or shell script?

972

Write the alter statement to enable all the triggers on the t.students table.

1125

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1000

how to convert character strings to dates? : Sql dba

1062

Can we join 3 tables in sql?

1044

What are different types of indexes?

1010

What is a file delimiter?

1096

how to shut down the server with 'mysqladmin'? : Sql dba

1013

Why is theta join required?

1146

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1582

What is %type in pl sql?

968

What is trigger in sql? Explain

997

Which table is left in left join?

1014

What types of commands can be executed in sql*plus?

1109