Re: sql query

On Tue, 18 Jun 2002 13:44:32 -0500, "GM" <GM_at_nospam.com> wrote:

> I have a table with 800Millian rows. I want to write a sql query where i
>want to find out how many rows fall between certain dates. It is bascially
>find out each quater data in year for last 6 years.
>
>Basically combining the below statments into one single sql query
>
>select count(*) from orddet where order_date >= '01-JAN-1996' and order_date
><= '31-MAR-1996';
>select count(*) from orddet where order_date >= '01-APR-1996' and order_date
><= '30-JUN-1996';
>select count(*) from orddet where order_date >= '01-JUL-1996' and order_date
><= '30-SEP-1996';
>select count(*) from orddet where order_date >= '01-OCT-1996' and order_date
><= '31-DEC-1996';
>
>select count(*) from orddet where order_date >= '01-JAN-1997' and order_date
><= '31-MAR-1997';
>select count(*) from orddet where order_date >= '01-APR-1997' and order_date
><= '30-JUN-1997';
>select count(*) from orddet where order_date >= '01-JUL-1997' and order_date
><= '30-SEP-1997';
>select count(*) from orddet where order_date >= '01-OCT-1997' and order_date
><= '31-DEC-1997';
>
>Thx
>
>

IIRC the to_char function still support the Q format model, where q is for quarter.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jun 18 2002 - 15:14:32 CDT