Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: non duplicate records querry


    I have a table with 701 duplicate records. The number
    of non duplicate records from this table is 179
    I tryed to make a querry like :

    Select Distinct count(recordname) from table

    but the result is the same 701

    What is the proper querry to get the 179 result ?

  2. #2
    Join Date
    Mar 2006
    select count(distinct(recordname)) from tablename

Posting Permissions

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