Count Unique

  • Thread starter Thread starter jfm
  • Start date Start date
J

jfm

I've seen this before in the SQL view but can't seem to
find it now . . .

I have a database with one column of records. Would
anyone have the SQL statements that would create one query
to count the unique records only?

Any help is appreciated. Thanks.
 
Try something along the lines of
SELECT COUNT(myCol)
FROM
(SELECT DISTINCT myCol FROM MyTable)

Hope This Helps
Gerald Stanley MCSD
 
Back
Top