i have a table in which we are appending data on daily basis. we want to take all those record which have some changes. no need to store unique record. so we want a query which can be delete all those which are duplicate.
our SQL table is :
NewCode Outlet_Name Outlet_Location Outlet_Location_Text Loc Updated Date 122 KAMAL BAKERY 5K GREEN DISTRIBUTION - KARACHI KHI 8-May-17 445 BOLAN ICE DEPOT W3 EGC Distributor KHI 8-May-17 450 CAFE MERHABA W3 EGC Distributor KHI 8-May-17 122 KAMAL BAKERY 3K SHOAIB KHALIQ KHI 9-May-17 445 BOLAN ICE DEPOT W3 EGC Distributor KHI 9-May-17 450 CAFE MERHABA W3 EGC Distributor KHI 9-May-17
After Removing Duplicates:
NewCode Outlet_Name Outlet_Location Outlet_Location_Text Loc Updated Date 122 KAMAL BAKERY 5K GREEN DISTRIBUTION - KARACHI KHI 8-May-17 445 BOLAN ICE DEPOT W3 EGC Distributor KHI 8-May-17 450 CAFE MERHABA W3 EGC Distributor KHI 8-May-17 122 KAMAL BAKERY 3K SHOAIB KHALIQ KHI 9-May-17