Re: regd count(count(*)) in group by

On 26 Jul 2002, Rod Taylor wrote:

> Try this:
>
> SELECT count(*)
> FROM (
> SELECT count(*)
> FROM test
> GROUP BY date_trunc('day', test_date)
> ) as qry;

Or this:

SELECT COUNT(*)
FROM (
SELECT DISTINCT(date_trunc('day', test_date))
FROM test
);

Matthew.