count(distinct field_name)

Results 1 to 2 of 2

Thread: count(distinct field_name)

  1. #1
    Join Date
    Dec 1969

    Default count(distinct field_name)

    i write this sql statement in to ways and both of them doesn&#039;t work (i have remarks)<BR>the sql statements is connecting to database access 2000<BR>1. SELECT count(distinct field_name) FROM tbl_name<BR>2. SELECT count(distinct(field_name)) FROM tbl_name<BR><BR>just this simple one works<BR>SELECT count(field_name) FROM tbl_name<BR><BR>but i must the distinct for uniqe fields<BR>what is the problem?

  2. #2
    Join Date
    Dec 1969

    Default Does this help?

Posting Permissions

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