Posted on 2007-10-05
I have a table that I need to return all columns but ONLY the ones with a DISTINCT value in one of the columns.
This code retrns 340 rows but 12 are duplicates ( product_desc)
eq_eaches,eq_converted,eq_twelve_oz,eq_fountain,eq_sellunit from dbo.product
where product_desc like 'BIBPST%'
order by product_desc
how would I change it to ONLY show me the ones with distinct prduct_desc?