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

    Unanswered: non duplicate records querry

    Hi,

    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
    Posts
    4
    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
  •