Hi frens, Need your expertise to help solve the below sql problem.Im having problem to add another condition inorder for me to get 3 lines (highlighted in blue in the excel sheet attachment).At the moment I'm only getting 2 lines using the below sql.Tried various ways but wid no luck.Please help. select * from fwcatns_testbintxn where bintype ='R' and bincategory ='H' and step like 'T-ET%' and activity like '%YieldCheck%'and lottxncounter = (select max(lottxncounter) from fwcatns_testbintxn where lotobject = '00000e31.24050a80.4302b173.0011344b.5452')