If I understand what you're
asking try:
select count_1, count_2
from
(select count(*)
AS count_1 from leads where
ad_code = '555'),
(select count(*)
AS count_2 from leads where ad_code =
'222')
;
Duane
-Original Message-From: Jeannie Stevenson
[mailto:[EMAIL PROTECTED]Se
m: Duane Lee - EGOVX
Sent: Tuesday, June 01, 2004 9:54 AMTo: 'Jeannie
Stevenson'; postgresqlSubject: RE: [GENERAL] multiple count
functions in a select statement
If I understand what you're
asking try:
select count_1, count_2
from
(select count(*)
AS
On Monday 31 May 2004 04:32 pm, Oliver Elphick wrote:
> On Thu, 2004-05-27 at 17:38, Jeannie Stevenson wrote:
> ...
>
> > In MSSQL I would use
> >
> > select
> > count_1=(select count(ad_code) AS "CP" from leads where ad_code =
> > '555'),
> > count_2=(select count(ad_code) AS HED" from leads where
