Where clause

Поиск
Список
Период
Сортировка
От Michael Landin Hostbaek
Тема Where clause
Дата
Msg-id 20070626082405.GA67974@mich2.itxmarket.com
обсуждение исходный текст
Ответы Re: Where clause
Re: Where clause
Список pgsql-sql
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; 

I guess I have to put where (click = true or view = true) - and
differentiate them in the SELECT target.. ?


Many thanks for any input, 

Mike


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