Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / sql query to find duplicate records in a table in sql server
Ask Question
Anubhav Sharma
Anubhav Sharma

Student

The Anubhav portal was launched in March 2015 at the behest of the Hon'ble Prime Minister for retiring government officials to leave a record of their experiences while in Govt service .

Message

1 Answers

Ravi Vishwakarma
Ravi Vishwakarma 16 Jul 2024
Report Abuse

To find duplicate records in your Employee table based on the EmployeeID and Email columns, you can use a query with the GROUP BY and HAVING clauses. 

Here is an example query to identify duplicates:

SELECT 
    EmployeeID, 
    Email, 
    COUNT(*) AS DuplicateCount
FROM 
    Employee
GROUP BY 
    EmployeeID, 
    Email
HAVING 
    COUNT(*) > 1;

Explanation:

  • SELECT EmployeeID, Email, COUNT(*) AS DuplicateCount: This part of the query selects the EmployeeID, Email, and a count of how many times each combination appears.
  • FROM Employee: Specifies the table to query.
  • GROUP BY EmployeeID, Email: Groups the results by EmployeeID and Email to aggregate the counts.
  • HAVING COUNT(*) > 1: Filters the results to include only groups with a count greater than 1, indicating duplicates.

This query will return a list of EmployeeID and Email combinations with more than one occurrence in the Employee table, along with the count of those duplicates.

Read more 

How do I use the GROUP BY clause to aggregate data in SQL Server?

Implement row-level security in SQL Server to restrict access to data to users.

Protect SQL Server database against SQL injection attacks?

How do I write CRUD operations to modify data in SQL Server tables?

MindStick Training