Forum OpenACS Q&A: Response to SQL: Distinct Counting Help

Collapse
2: Response to SQL: Distinct Counting Help (response to 1)
Posted by Don Baccus on 08/01/01 03:35 AM
select count(*) from (select distinct user_id from page_view) foo;

PG at least requires the subselect alias (foo) ...