Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: query

Re: query

From: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Thu, 30 Sep 1999 05:23:46 GMT
Message-ID: <CtCI3.1953$S2.18018418@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:23:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US