Distinct Count

Results 1 to 2 of 2

Thread: Distinct Count

  1. #1
    Join Date
    Dec 1969

    Default Distinct Count

    I am looking for the proper SQL syntax that will COUNT the number of unique records. I get an error message using the below.<BR><BR>SELECT distinct COUNT [Reviewer]<BR>FROM reviews;<BR><BR>Thanks<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Distinct Count

    Thanks to White Knight:<BR><BR>SELECT Reviewer, count(*)<BR>FROM Reviews<BR>GROUP BY Reviewer

Posting Permissions

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