How to find the duplicate records on certain fields in SQL Server ?

Published on August 29, 2016 by abundantcode

Filed under SQL Server

Last modified August 29, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 4348 times

You can use the group by and having clause in your T-SQL query to find out the duplicate records from the table.

How to find the duplicate records on certain fields in SQL Server ?

Lets have a look at the query that uses the group by and having clause on the Person table in the AdventureWorks database. The firstname column is used as the criteria to find out if the records are duplicate.

Use AdventureWorks2014
GO
select FirstName, count(*) as count
  from Person.Person
  group by FirstName
  having count(*) > 1

image

Leave a Comment


x

You might be Interested in these Posts

C Program to find the G.C.D of a number using Recursive function

Problem Write a program in C to find the find the G.C.D of a number using recursion and display the ...

C Program to print a Half Pyramid using *

Problem Write a program in C to print Half pyramid using * as shown. * * * * * * * * * * ...

C Program to display Positive factors of a number

Problem Write a program in C to display all the positive factors of a number enter by the user. Ho...