Re: count(*) in sql statement
From: Heikki Rissanen <rissahe1_at_news.ougf.fi>
Date: 31 May 1994 15:40:58 +0300
Message-ID: <2sfb8qINNda2_at_news.ougf.fi>
Date: 31 May 1994 15:40:58 +0300
Message-ID: <2sfb8qINNda2_at_news.ougf.fi>
Mark Citron (mcitron_at_hsc.usc.edu) wrote:
: Is it possible to select two different counts in one statement? That is
: I have a list of dates, can I select the number of dates between dateA and dateB
: and also the number of dates between dateC and dateD? All on one line of output.
You could try something like
SELECT SUM(DECODE(SIGN(dateA-fld),1,0,
DECODE(SIGN(fld-dateB),1,0,1))) Count1, ...
You may have to add some to_dates somewhere depending on your date formats.
Regards,
Hessu
-- --------------------------------------------------------------------- Heikki Rissanen, United Papermills, Rauma, Finland Email: heikki.rissanen_at_ra.upm.yhtyneet.mailnet.fi ---------------------------------------------------------------------Received on Tue May 31 1994 - 14:40:58 CEST