Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008
    Posts
    1

    Unanswered: distinct count of 2 attributes

    Does anyone know how to do a distinct count of 2 attributes from the same table?

    I get an syntax error msg when I try to do this.

    Thank you

  2. #2
    Join Date
    Aug 2005
    Posts
    140
    As far as I know, you can't do something like this:

    select count(distinct col1,col2) from table;

    try this:

    select distinct col1, col2 from table into temp temp_table with no log;
    If you are working in dbaccess, you get the actual count after execution, if you are not:
    select count(*) from temp_table;

Posting Permissions

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