C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

Appukuttan (619)
Babu Akkandi (470)
divya (321)

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

How to Check for Duplicate Records in SQL Server

Posted Date: 04 May 2008	Resource Type: Code Snippets	Category: SQL
Author: http://dotnetvj.blogspot.com	Member Level: Diamond
Rating:	Points: 10

The following code sample shows how to Check for Duplicate Records in SQL Server
SELECT email,
COUNT(email) AS NumOccurrences
FROM users
GROUP BY email
HAVING ( COUNT(email) > 1 )

Responses

Author: HereToLearn.Net !! 05 May 2008

Member Level: Gold Points : 2

Hey that helped me a lot....Thanks

Author: andy robarts 05 May 2008

Member Level: Gold Points : 2

SELECT

FROM
tablename
GROUP BY

HAVING
count(*) > 1

Author: venkat kamal 05 May 2008

Member Level: Gold Points : 2

nice but there are other ways also......

Author: santhoshkumar 09 May 2008

Member Level: Gold Points : 2

Nice one

Author: gokul 12 May 2008

Member Level: Silver Points : 2

Hi thanks! It was helpful

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: How to write a stored procedure to search
	Previous Resource: How to Copy Data from one table to another
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design