Re: Where clause

Поиск
Список
Период
Сортировка
От news.gmane.org
Тема Re: Where clause
Дата
Msg-id f5ravm$37c$1@sea.gmane.org
обсуждение исходный текст
Ответ на Where clause  (Michael Landin Hostbaek <mich@the-lab.org>)
Ответы Re: Where clause  (Michael Landin Hostbaek <mich@the-lab.org>)
Список pgsql-sql
Michael Landin Hostbaek skrev:
> Hello, 
> 
> I have a table called tracking, with a contactid varchar, click bool,
> view bool and cid varchar.
> 
> I would like to put the following into one single query if possible:
> 
> // Number of clicks
> select cid,count(distinct contactid) from tracking where click =
> true group by cid; 
> 
> // Number of views
> select cid,count(distinct contactid) from tracking where view =
> true group by cid; 

Untested, not the cleverest formulation, but something like this should
work:

SELECT * FROM
(
select cid,count(distinct contactid) from tracking where click =
true group by cid
) c1
FULL OUTER JOIN
(
select cid,count(distinct contactid) from tracking where view =
true group by cid
) c2
USING (cid);



В списке pgsql-sql по дате отправления:

Предыдущее
От: Wiebe Cazemier
Дата:
Сообщение: Delete rules and functions
Следующее
От: "Andrej Ricnik-Bay"
Дата:
Сообщение: Re: yet another simple SQL question