Re: multiple count functions in a select statement
От | Duane Lee - EGOVX |
---|---|
Тема | Re: multiple count functions in a select statement |
Дата | |
Msg-id | 64EDC403A1417B4299488BAE87CA7CBF01CD0E48@maricopa_xcng0 обсуждение исходный текст |
Ответ на | multiple count functions in a select statement ("Jeannie Stevenson" <webteam@wes-state.com>) |
Список | pgsql-general |
Sent a little too quickly the sql should look like this:
select count_1, count_2 from
(select count(*) AS count_1 from leads where ad_code = '555') AS DMY1,
(select count(*) AS count_2 from leads where ad_code = '222') AS DMY2
;
-----Original Message-----
From: Duane Lee - EGOVX
Sent: Tuesday, June 01, 2004 9:54 AM
To: 'Jeannie Stevenson'; postgresql
Subject: RE: [GENERAL] multiple count functions in a select statementIf 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:webteam@wes-state.com]
Sent: Thursday, May 27, 2004 9:39 AM
To: postgresql
Subject: [GENERAL] multiple count functions in a select statementHello listI'm a MSSQL convert and I'm running postgresql 7.2I'm trying to create a statement in which display multiple counts on a tableIn MSSQL I would useselectcount_1=(select count(ad_code) AS "CP" from leads where ad_code = '555'),count_2=(select count(ad_code) AS HED" from leads where ad_code = '222'),etcI've searched the docs but to avail.Any help, suggestions, pointers, would be appreciatedThanksJeannie
В списке pgsql-general по дате отправления: