I want to write one query How to get Matched records and unmatched records in t

I want to write one query
How to get Matched records and unmatched records in table?

Question Posted / guest

4 Answers
9655 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I want to write one query How to get Matched records and unmatched records in table?..

Answer / mohan

full outer join can be used to get both unmatched and
matched records..

Is This Answer Correct ?

5 Yes

0 No

I want to write one query How to get Matched records and unmatched records in table?..

Answer / vimal

We can use minus query and intersect query

unmatched: records in a but not in b
select *
from a
minus
select *
from b ;

matched: recrods in a and in b
select *
from a
intersect
select *
from b ;

Is This Answer Correct ?

4 Yes

1 No

I want to write one query How to get Matched records and unmatched records in table?..

Answer / gowthami

i think..By using joins we can get required records.based on
your requirements we should choose left outer join or right
outer join

Is This Answer Correct ?

1 Yes

2 No

I want to write one query How to get Matched records and unmatched records in table?..

Answer / gowthami

i think..By using joins we can get required records.based on
your requirements we should choose left outer join or right
outer join

Is This Answer Correct ?

1 Yes

2 No

Post New Answer