Hi Everyone,
This is my sample data.
Have to group by by rollno. and then for the set of unique roll no if any of the values in prime contains " pass" have to return "Pass" for all the associated records
else return "No"
basically if atleast one pass is there for a roll no. then return pass for all the records containing that roll no. or else return "No"
Please help
appreciate it
