Results 1 to 2 of 2

Thread: multiple records in a database

  1. 12-18-2002, 01:38 AM #1
    allen
    allen is offline Registered User
    Join Date
    Dec 2002
    Posts
    2

    multiple records in a database

    i have encounter a problem.
    in a table designed by foxpro,there were some mutiple records.i want to look up the table to find the same record,but i dont know how to do.could some one help me?
    send me a email! thank u!

    address:
    allenleung@sina.com
    Reply With Quote Reply With Quote
  2. 12-18-2002, 09:14 AM #2
    wileyjack
    wileyjack is offline Registered User
    Join Date
    Oct 2002
    Location
    Macon
    Posts
    18
    You can use GROUP BY...HAVING to see the duplicate records..


    SELECT RecordID, Count(RecordID) AS RecordCount
    FROM YourTable
    GROUP BY RecordID
    HAVING COUNT(RecordID) > 1
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules