duplicates query

Results 1 to 2 of 2

Thread: duplicates query

  1. #1
    Join Date
    Dec 1969

    Default duplicates query

    Hello,<BR> Can any one help me with this please. I am new to asp. I Have a table that has a field with duplictes. I will have to write a query that returns the duplicates records and their count. I tried creating a temp table but that doesn&#039;t seem to work.<BR><BR>Thank you In advance<BR>Bye<BR>Raju

  2. #2
    Join Date
    Dec 1969

    Default RE: duplicates query

    SELECT someFieldOrFieldsThatIdentifiesRecords, Count(*)<BR>FROM table<BR>GROUP BY list, each, field, that, defines, whether, record, is, duplicate, or, not<BR><BR>By leaving a field out of the GROUP BY list, you can ignore it in deciding if the records are duplicates or not. So, for example, you could ignore recordIDs.<BR><BR>

Posting Permissions

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