Hi, I have some transaction data and I would like to retain the order of the products the customer have bought but I want to delete the duplicates...for example, if in one tranaction they buy first Milk, Egg, Egg , Fruit. I just want to keep Milk, Egg and Fruit. Basically I don't want to use select distinct as I will loose the order of buying.Please find below the Input and the output I would like to have. Thank you That's the table I have TRAN_ID TRAN_DT PROD_NM 10442673557 01Oct2014 Food to Go 10442673557 01Oct2014 Dairy 10442673557 01Oct2014 Impulse 10442673557 01Oct2014 Impulse 10442673557 01Oct2014 Impulse 10442673558 02Oct2014 Bakery 10442673558 02Oct2014 Bakery 10442673558 02Oct2014 Meat 10442673558 02Oct2014 Dairy 10442673558 02Oct2014 Dairy 10442673558 02Oct2014 Fruit That's What I want TRAN_ID TRAN_DT PROD_NM 10442673557 01Oct2014 Food to Go 10442673557 01Oct2014 Dairy 10442673557 01Oct2014 Impulse 10442673558 02Oct2014 Bakery 10442673558 02Oct2014 Meat 10442673558 02Oct2014 Dairy 10442673558 02Oct2014 Fruit
... View more