I need to fetch master record and potential match from the column match result in my table which having same groupid

Question

I have one table in which there are many records, now I need to fetch master record and potential match records from my column match result which having same groupid on the basis of it's top parented.

please provide some sample test data and expected result – TheGameiswar Nov 11 '16 at 09:32 — TheGameiswar, Nov 11 '16 at 09:32
please see the image – Manish Prajapat Nov 11 '16 at 09:33 — Manish Prajapat, Nov 11 '16 at 09:33
images might be blocked in some domains, – TheGameiswar Nov 11 '16 at 09:37 — TheGameiswar, Nov 11 '16 at 09:37

score 1 · Answer 1 · answered Nov 11 '16 at 11:17

1

You probably just want something like

select *
from [table] as master
inner join [table] as match on master.groupid = match.groupid
where master.match_result = 'Master Record'
and match.match_result = 'Potential Match'

answered Nov 11 '16 at 11:17

James Casey

2,447
1
11
19

I need to fetch master record and potential match from the column match result in my table which having same groupid

1 Answers1