Basically I have a table with more than 10 columns and the first row has Employee Numbers.
I want to do a Select Distinct by Employees numbers to remove duplicates and then I want to keep all values That are from the resulting filtered Employees numbers, meaning I want to keep all row and matching values of the remaining columns.
I tried a similar solution, but That way only returns the column of Employees Number in this case right? It Will do a Select Distinct in That column, but I Will not have the values of the other ones.
@mikePontes, you can give all the column names to achieve it separated by commas or to be precise assign the column names to array or list and use the variable there.
Basically, a duplicate datarow means having all the values duplicate, so you first need to decide how you want to extract the data, you should have one identifier to consider your data as duplicate else this query won’t work.