Re: [SQL] Combining two SELECTs by same filters

2005-10-26 Thread Bruno Wolff III
On Wed, Oct 26, 2005 at 18:16:13 +0300, Volkan YAZICI <[EMAIL PROTECTED]> wrote: > And I want to collect the count of sales at hour = 21 and hour = 22. > For this purpose, I'm using below SELECT query: > > => SELECT > -> (SELECT count(id) FROM sales > -> WHERE id = 2 > -> AND

Re: [SQL] Combining two SELECTs by same filters

2005-10-26 Thread Michael Fuhr
On Wed, Oct 26, 2005 at 06:16:13PM +0300, Volkan YAZICI wrote: > => SELECT > -> (SELECT count(id) FROM sales > -> WHERE id = 2 > -> AND date_trunc('hour', dt) = '2005-10-25 21:00:00'), > -> (SELECT count(id) FROM sales > -> WHERE id = 2 > -> AND date_trunc('h

Re: [SQL] Combining two SELECTs by same filters

2005-10-26 Thread Scott Marlowe
On Wed, 2005-10-26 at 10:16, Volkan YAZICI wrote: > => SELECT > -> (SELECT count(id) FROM sales > -> WHERE id = 2 > -> AND date_trunc('hour', dt) = '2005-10-25 21:00:00'), > -> (SELECT count(id) FROM sales > -> WHERE id = 2 > -> AND date_trunc('hour', dt) =