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 по дате отправления: