In above scenario 3 records will get display.
1 A 2 2
1 A 0 1
1 A 1 0
CREATE TABLE Persons (LastName varchar(255),FirstName varchar(255),Sample1 varchar(255),Sample2 varchar(255)); Insert Into Persons values('1','A','Y','N') Insert Into Persons values('1','A','Y','Y') Insert Into Persons values('1','A','N','Y') Insert Into Persons values('1','A','Y','Y')
Thanks