Hello,
I have the following data
Customer RowNum SalesOrder Customer
(100915) (2) (100915-2) (ARORA)
(100915) (1) (100915-1) (ARORA)
(100576) (1) (100576-1 ) (AMKOR)
(100555) (1) ( 100555-1 ) (JACK)
If you look at the first two records you'll see its the same customer. I need to keep the record with RowNum 2 and delete the record with RowNum 1. Is there any way to do a this in SQL? I'm using SQL Server 2008