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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Writing A Select Statement To Return a Count Of Unique Dates In aTable 2
Unique Count 1
Counting records in a query 9
Access Query - "Duplicate Records Selected" 5
loop though records in a query? 5
Unique Records 6
Create a distinct Join 3
Count unique field1 combined with count field2, both grouped andungrouped 3

Back
Top