Method 1: Deleting duplicate rows from a table using the “ROW_NUMBER ()” function and JOINS. Execute the following code which is using ROW_NUMBER function and JOIN to remove duplicate rows from the ...

LINQ in .NET returning duplicate rows from a working SQL view ... AS users FROM table1 AS a INNER JOIN table2 AS b ON a.Id = b.Id GROUP BY b ... it simply took the first column in the table.