Hi Expert,
I am looking for the below solution
if Combination of lot and reason are more than then i want to take only one records and i have to take first record transaction number .Now we can group by this two field i.e reason and lot and we will get the record but how can i get the non grouping record and the first transaction number.
Below is the input and output data i want.
o/p
Regards,
Bikram