How do I get a subset of my table where only 2 of the seven fields that I need in the result can be and must be distinct?

select distinct pid,lot from products
(gives the right # of records)

select distinct pid,lot,id,price1,price2,price3,price4,price5,cost
(gives too much distinction even though I need the other fields)

Thanks :)