Count Unique

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.
 
G

Gerald Stanley

Try something along the lines of
SELECT COUNT(myCol)
FROM
(SELECT DISTINCT myCol FROM MyTable)

Hope This Helps
Gerald Stanley MCSD
 
Top