dot net tips, DotNet tips, .Net Tips,Dot Net tips and tricks,Dot Net Solutions, OOPS Concept in C#,SQL Server, LinQ, Ajax, Java script, JQuery, Server Error details, daily .net tips and tricks , DotNet Interview Questions.
Get duplicate rows of a table
SELECT COUNT(*), colname FROM TABLE GROUP BY colname HAVING COUNT(*) > 1
