Get count of distinct dates

pearl2 · #1 (**permalink**) 03-11-10, 12:20

Hi everyone,

This seems like a trivial query but I can't figure out how to do it

How do you get a count of the number of distinct dates in a table?

Suppose I've:

2010-03-10
2010-03-08
2010-03-10
2010-02-10
2010-02-10
2010-01-24

There are four distinct dates - I'm trying to get that number.

Thanks in advance

(Ah sorry, I kept getting Gateway error and I thought the submission didn't go through - but it did. Didn't know I can't delete my own posts after I saw the duplicates.)

mike_bike_kite · #2 (**permalink**) 03-11-10, 12:34

Code:

select count(distinct fieldname) from table

PS I deleted the duplicate posts

r937 · #3 (**permalink**) 03-11-10, 13:02

SELECT COUNT(*) FROM ( SELECT columnname FROM daTable GROUP BY columnname ) AS tadaaaa

pearl2 · #4 (**permalink**) 03-11-10, 19:00

Wonderful! Thank you so much, Mike and r937

I swear I've tried queries like yours, with near misses.

Cheers!

Internet Services

Web Development

Digital Marketing

Consumer Tech