Re: Help needed in SQL Query

From: Surendra <surendramuthye_at_yahoo.com>
Date: 12 Aug 2003 14:16:00 -0700
Message-ID: <742a5eb5.0308121316.210ea5d6_at_posting.google.com>


I think I have not been clear in my requirements

If there are 3 dates in a month, the indexes returned should be 1, 2, 3 based on what date is passed in. So if the input date is 07/14/2003, since it is the first date in the month of July 2003, I should get the index value of 1. If I input the date as 08/01/2003, since it is the 1st of the 3 date entries for August 2003, the query should return a value of 1. If I use 08/29/2003 as the input, the query should return an index of 3 as it is the third date in the month of August.

"Alan Mills" <Alan.Mills_at_xservices.pants.fujitsu.com> wrote in message news:<bha7po$qqs$1_at_news.icl.se>...
> "Surendra" <surendramuthye_at_yahoo.com> wrote in message
> news:742a5eb5.0308111952.eca63db_at_posting.google.com...
> > I have a table that has fields GRP_CODE & END_DATE. For a given
> > GRP_CODE and a given month of a year, there may be 1, 2 or 3 END_DATE
> > values.
> > For Example,
> > GRP_CODE END_DATE
> > AA 07/14/2003
> > AA 07/28/2003
> > BB 07/14/2003
> > BB 07/28/2003
> > AA 08/01/2003
> > AA 08/15/2003
> > AA 08/29/2003
> > BB 08/01/2003
> > BB 08/15/2003
> > BB 08/29/2003
> > ...
> >
> > I have to develop a query that has one input parameter, a date. The
> > query should return either 0, 1, 2, or 3 based on the match with the
> > END_DATE field.
> >
> > In the above example, here is what the query should return the
> > following results for various input dates
> >
> > Input Date Query Output
> > 08/01/2003 1
> > 08/15/2003 2
> > 08/29/2003 3
> > 08/30/2003 0
> > 07/14/2003 1
> > 07/28/2003 2
> >
> > Can anybody help me with how the query can be written?
> >
> > Thanks in advance.
>
> Look up COUNT and GROUP BY in the manuals
Received on Tue Aug 12 2003 - 23:16:00 CEST

Original text of this message