Loading
I am getting duplicate rows how to remove in sql server
  • Mageshwaran R

    Mageshwaran RPosted Dec 26, 2020, 10:37 AM

    Hi Nabin,
    Try this query,
    1. CREATE TABLE Employee  
    2.     (   
    3.     [ID] INT identity(1,1),   
    4.     [FirstName] Varchar(100),   
    5.     [LastName] Varchar(100),   
    6.     [Country] Varchar(100),   
    7.     )   
    8.     GO   
    9.       
    10.     Insert into Employee ([FirstName],[LastName],[Country] )values('Raj','Gupta','India'),  
    11.                                 ('Raj','Gupta','India'),  
    12.                                 ('Mohan','Kumar','USA'),  
    13.                                 ('James','Barry','UK'),  
    14.                                 ('James','Barry','UK'),  
    15.                                 ('James','Barry','UK')  
    16. SELECT [FirstName],   
    17.     [LastName],   
    18.     [Country],   
    19.     COUNT(*) AS CNT  
    20. FROM [SampleDB].[dbo].[Employee]  
    21. GROUP BY [FirstName],   
    22.       [LastName],   
    23.       [Country]  
    24. HAVING COUNT(*) > 1;  
     
  • Rajanikant Hawaldar

    Rajanikant HawaldarPosted Dec 26, 2020, 9:57 AM

    use distinct