I have this table on SS 2005 , ItemsDiscount , it is having those columns
PKey INT , ItemID INT , Discount Dec
I want to return list of items and their discounts in the table BUT i dont want ItemID to repeat , meaning show only first occurance of ItemID and its discount and dont repeat it in case if another discount is there for same itemid
Example Data ,
ItemID , Discount
then i want to return
What is the select statement to return this ?
View Complete Post