Professional Web Applications Themes

Could anyone help me to remove duplicate rows? - ASP.NET General

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 [url]http://www.developersdex.com[/url] *** Don't just participate in USENET...get rewarded for it!...

  1. #1

    Default Could anyone help me to remove duplicate rows?

    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 [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    TaeHo Yoo Guest

  2. #2

    Default Re: Could anyone help me to remove duplicate rows?

    TaeHo Yoo <yootaeho> wrote in
    news:#VBSQEzTDHA.1364TK2MSFTNGP10.phx.gbl:
    > 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.
    [url]http://www.crtimmonsinc.com/[/url]
    Chris R. Timmons Guest

Similar Threads

  1. Question Remove Duplicate Rows in MySQL Table Having No Primary Key or Unique Index
    By deltaforce in forum Brainstorming Area
    Replies: 0
    Last Post: July 25th, 10:14 AM
  2. MySql UPDATE problem with duplicate rows
    By Jon Maz in forum MySQL
    Replies: 7
    Last Post: May 17th, 09:30 AM
  3. How to delete duplicate rows?
    By Clodoaldo Pinto in forum PostgreSQL / PGSQL
    Replies: 4
    Last Post: February 4th, 11:11 AM
  4. how to eliminate duplicate rows?
    By dave in forum ASP Database
    Replies: 7
    Last Post: June 29th, 12:19 AM
  5. Remove duplicate entries
    By Court in forum ASP Database
    Replies: 1
    Last Post: December 18th, 02:16 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139