I want to extract data from a table .... i want to extract data for the mentioned three scenarios
Here is the sample table structure and data.
Create table Tbl1
(Parent varchar(50),
ParentRev varchar(50),
Child varchar(50),
childrev varchar(50),
TNum varchar(50))
insert into tbl1('Parent1','001','child1','001','104');
insert into tbl1('Parent1','001','child1','001','104');
insert into tbl1('Parent1','001','child1','002','104');
insert into tbl1('Parent1','001','child2','002','104');
insert into tbl1('Parent1','001','child1','001','104');
insert into tbl1('Parent1','001','child1','002','104');
insert into tbl1('Parent1','001','child3','003','105');
insert into tbl1('Parent1','002','child4','001','106');
insert into tbl1('Parent2','001','child5','001','102');
insert into tbl1('Parent2','001','child6','004','102');
insert into tbl1('Parent2','001','child7','005','110');