I want to build a sql server query, result should display duplicate of serial numbers where it is assigned to only two specific products


There are multiple columns in a table and I want a query to find out serial numbers associated with two specific products.
I have tried “or” condition but it is giving results of of serial numbers which is associated to one product also.
I am stuck here, it would be great if I got help.