do/for loop script needed?

[#1]

Hi All,

Please help me implement below requirement.

Data looks like below

Number	Sub-Number	Status
1	1.1	pass
1	1.2	fail
1	1.3	reject
2	2.1	pass
2	2.5	pass
3	3.2	fail
3	3.3	fail
3	3.4	reject

Requirement:

get the list of numbers for which, status is only 'pass' for all the Sub-Number.

to make it clear, if corresponding status for all the Sub-Numbers for a given Number is ''pass'', then only it should appear in output list.

so in above example, output list will contain only number 2.

please help.

any suggestion appreciated.

Thanks&Regard

Jyothi

[#2]

wow! it worked.

so if i want to add 5 fields, i should be adding all 5 fields in Group By clause is it?

I hope it wont impact the result

Thanks a lot Anbu!

[anbu1984]

Yes. If you are not getting correct result, then post the script you tried and expected output