dbo slot

SELECT wall, x, y FROM dbo.Slot GROUP BY wall, x, y HAVING COUNT(*) = 2 Then we do an INNER JOIN between the original dbo.Slot table and this set of duplicate values, as well as adding a ROW_NUMBER value to make it easier to choose a single row to keep if the other duplicates are removed: games 88 slot