select distinct EmployeeNo ,max(Column1) as Column1 ,max(Column2) as Column2 from yourtable group by EmployeeNo
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)