Could anyone help me to remove duplicate rows?

Discussion in 'ASP .Net' started by TaeHo Yoo, Jul 21, 2003.

  1. TaeHo Yoo

    TaeHo Yoo Guest

    I have a table that has more than 1 milion rows so practically it is
    impossible to remove all duplicate rows by hand.
    Could you help me to remove those duplicate rows at all?
    This table doesn't have primary key( identity ) column.

    Say Table name => MyTable
    Column => Col1,Col2,Col3
    No primary key column here.

    Thanks a lot in advance.



    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
     
    TaeHo Yoo, Jul 21, 2003
    #1
    1. Advertising

  2. TaeHo Yoo <> wrote in
    news:#:

    > I have a table that has more than 1 milion rows so practically
    > it is impossible to remove all duplicate rows by hand.
    > Could you help me to remove those duplicate rows at all?
    > This table doesn't have primary key( identity ) column.
    >
    > Say Table name => MyTable
    > Column => Col1,Col2,Col3
    > No primary key column here.


    Have you looked into using SELECT DISTINCT?

    Hope this helps.

    Chris.
    -------------
    C.R. Timmons Consulting, Inc.
    http://www.crtimmonsinc.com/
     
    Chris R. Timmons, Jul 21, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    3
    Views:
    698
  2. =?Utf-8?B?QXNoYQ==?=

    deleting duplicate rows in a dataset

    =?Utf-8?B?QXNoYQ==?=, Jul 24, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    3,133
    Naveen K Kohli
    Jul 24, 2004
  3. Matt B
    Replies:
    6
    Views:
    479
    Matt B
    Oct 8, 2005
  4. heylow
    Replies:
    6
    Views:
    135
    Tad McClellan
    Sep 15, 2007
  5. Joon Ki Choi
    Replies:
    4
    Views:
    150
    Joon Ki Choi
    Oct 10, 2012
Loading...

Share This Page