Coding Spirit is a blog for sharing general programming related concepts (usually) .NET, Asp.net, C#.net, Jquery, Ajax, Sql Server, PHP, MySql and any other as well as some discussion of programming concepts.
Friday, May 7, 2010
Find Duplicate Rows in a Sql Table
select SHORT_NAME, count(SHORT_NAME) as SN from TBLKOOL_GENERAL group by SHORT_NAME
No comments:
Post a Comment