SELECT branchcode,
COUNT(branchcode) AS branchcode
FROM Blocking_Ids
GROUP BY branchcode
HAVING ( COUNT(branchcode) >1 )
"uch as we try and prevent it, duplicate data still fin"
- How to Delete SQL Server Database Duplicate Rows from a Table Using a Specified Column List and No Temp Tables (view on Google Sidewiki)
No comments:
Post a Comment