How to remove duplicate rows from a table in SQL Server

SELECT OsoID, KpiMasterID,Title,StrategicPillarID , count(*)
FROM LinkKpiOsoStrategic
GROUP BY OsoID, KpiMasterID,Title,StrategicPillarID
HAVING count(*) > 1

databind on clint side button visible or false

// Server side

 public bool ShowImg(string actuals)
        {
            if (actuals == "1")
                return true;
            else
                return false;
        }

//Clint side

Visible='<%# ShowImg(Eval("Actuals").ToString()) %>'