Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006
    Posts
    1

    Unanswered: Deleting duplicate rows from a sybase table

    Dear All,

    Good Day!!!

    Any one know how to remove duplicate rows from a Sybase Table


    Regards

    Jackson

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    if only a few to delete
    set rowcount 1
    delete from table where duplicate and repeat for all duplicates
    else
    select distinct * into new from old
    then rename new to old

  3. #3
    Join Date
    Jun 2005
    Location
    Florida
    Posts
    1
    try this..

    select column from table
    group by column
    having count(column) > 1

    gm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •