Saturday, October 9, 2010

Get duplicated record from sql server table

Here query describes how to find duplicate record from a table in sql server

SELECT User_ID FROM tbl_Member
GROUP BY User_ID
HAVING count( * ) > 1

Thanks & Regards
Santosh Singh

1 comment:

  1. Nice article.

    You can submit your .net related article links on http://www.dotnettechy.com to get more traffic

    ReplyDelete