Wednesday, 14 August 2024

Find dupicates records using groupby

 SELECT 

    EmployeeNumber, 

    COUNT(*) as CountOfDuplicates

FROM 

    profiles

GROUP BY 

    EmployeeNumber

HAVING 

    COUNT(*) > 1;

No comments:

Post a Comment

remove duplicates in an sorted array

  using System; public class HelloWorld {          public static void Main(string[] args)     {         int[] ar={2,2,3,3,4,6,6};          C...