Deleting Records

• sumit.malik

  SSC Journeyman

  Points: 97

  More actions

  October 9, 2003 at 6:26 am

  #81230

  Hi,

  I have one question..I have one table named emp, which contains onw column called emp_name..and that coloumn contais following records

  Sam

  Tam

  Ram

  Dam

  Zam

  Sam

  Sam

  Tam

  As it shows I have some duplicate records in this . Now I just want to delete only the duplicate records i.e. if I have 4 Sam's then only three should get deleted .

  Thanks in advance

• Jeremy Kemp

  SSCertifiable

  Points: 6754

  More actions

  October 9, 2003 at 7:17 am

  #477694

  Have a look at this link: http://www.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=3&faqid=138

  It should give you some ideas.

  Jeremy

• shoayb

  Say Hey Kid

  Points: 709

  More actions

  October 10, 2003 at 1:39 am

  #477805

  you could do the following

  select distinct emp_name from emp

  and use the results to create a new table

  eg

  create table new_emp(emp_name varchar(100))

  insert into

  new_emp

  select distinct

  emp_name

  from

  emp

  Edited by - shoayb on 10/10/2003 01:39:51 AM