select * from A except select * from B

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 / shrawan kumar keshri

Answer Posted / shrawan kumar keshri

select * from A
except
select * from B

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

how many ways to get the current time? : Sql dba

1048

tell us something about heap tables. : Sql dba

1142

What is the limitation on the block size of pl/sql?

1038

what are string data types? : Sql dba

1093

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1106

Why triggers are used?

1037

what are dynamic queries in t-sql? : Transact sql

1070

What are the different types of joins in sql?

1913

What is integrity in sql?

1103

What are analytical functions in sql?

1078

Can we use views in stored procedure?

1085

How to prepare for oracle pl sql certification?

1109

What is a temp table?

1072

what are the type of locks ? : Sql dba

1010

How do we accept inputs from user during runtime?

1118