Re: query

From: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Thu, 30 Sep 1999 05:43:12 GMT
Message-ID: <QLCI3.1969$S2.18028224@France.EU.net>

Deepak Agrawal <deepak125_at_hotmail.com> a écrit dans le message : 7spd3r$kmt$1_at_news.vsnl.net.in...
> I have a table and the structure of table is rate,date,deposit in which
I
> am storing record
> of month march and other records are from month April to Feb.
> I want a monthly report in which I will get
record
> of march as well as
> month entered by the user, group by rate.
> please suggest how to solve this problem

SELECT SUM (deposit )
FROM table
GROUP BY rate, to_month (date )

A+ Received on Thu Sep 30 1999 - 00:43:12 CDT