For Finding the duplicate values in a SQL Server Table Column Posted on April 13, 2016 in SQL Server SELECT id, COUNT(id) FROM table1 GROUP BY id HAVING COUNT(id)>1; id–> table column name You might also like...The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine. (System.Data)Query Unicode Characters in SQL ServerSQL Server Temporary Table Vs Table VariableBoolean (true or false) data type in SQL Server Previous Post: Could not load file or assembly ‘Newtonsoft.Json, Version=6.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed’ or one of its dependencies. The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) Next Post: How do you delete Visual Studio Online/TFS Workspace Add Comment Cancel replyName (required) Email (required) Website (optional) Submit Comment