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

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

Answer Posted / shrawan kumar keshri

select * from A
except
select * from B

Is This Answer Correct ?

1 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I pipe the output of one isql to another?

943

What is the unique index?

1003

what is the difference between delete and truncate statement in sql? : Sql dba

1127

what are the differences among rownum, rank and dense_rank? : Sql dba

981

What is spool?

992

What is a database? Explain

1050

how many sql ddl commands are supported by 'mysql'? : Sql dba

955

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2069

what is a database lock ? : Sql dba

1092

Can we create table inside stored procedure?

904

What program will open a mdb file?

910

Mention what is the plv (pl/vision) package offers?

1055

how to extract a unit value from a date and time? : Sql dba

945

Is a secondary key the same as a foreign key?

953

what is isam? : Sql dba

951