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>


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

Original text of this message