sum month by month

Article View: borland.public.interbase.sql

Article #545

Back to borland.public.interbase.sql Previous Next

#545

From: ��
Date: Wed, 21 Nov 2007 05:50

9 lines
1155 bytes

Dear Sir

I have a table with 3 fields name , price and date (DD/MM/YYYY)

Now i want to sum month by month for all the year separetly
How can i do?
Please write the code

Thank you for your time

Technical Details

Message-ID: <4743c71f@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!newsfeed0.kamp.net!newsfeed.kamp.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,5f1b8536f425d03a,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "�������� �����������" <texilia@otenet.gr>
Newsgroups: borland.public.interbase.sql
Subject: sum month by month
Date: Wed, 21 Nov 2007 07:50:22 +0200
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 195.167.109.175
Message-ID: <4743c71f@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1195624223 195.167.109.175 (20 Nov 2007 21:50:23 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!newsfeed0.kamp.net!newsfeed.kamp.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail