🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #1021

Re: Pls help with procedure

#1021
From: Darius Evseicikas
Date: Sat, 10 Mar 2007 07:00
33 lines
2180 bytes
If I don't use the group I select all records, but I need only grouped 
records by objektas, year, month

-- 
Pagarbiai
Darius Evseicikas
==================
UAB "PROGMERA"
Maironio g. 3, LT-60149, Raseiniai
tel./faks. +370 428 70329
mob. +370 699 97390
ICQ 297832308

Informacija �iame prane�ime gali b�ti konfidenciali. Ji skirta tik asmeniui, 
kuriam yra adresuota. Jei J�s nesate tas asmuo (arba atsakingas u� �io 
prane�imo pristatym� tam asmeniui), J�s negalite skaityti, kopijuoti ar bet 
kaip platinti �io prane�imo viso ar i� dalies ir skleisti jame esan�ios 
informacijos. Jei �� prane�im� gavote per klaid�, pra�ome informuoti apie 
tai siunt�j� ir i�kart i�trinti visas �io prane�imo kopijas i� J�s� 
sistemos.
"Bill Todd" <no@no.com> wrote in message 
news:45f17701$1@newsgroups.borland.com...
> Darius Evseicikas wrote:
>
>> But I can't to group selected fields, how I can to write the group
>> section ?
>
> There is nothing to group. To use GROUP BY you must have at leas one
> aggregate function (MIN, MAX, COUNT, SUM, etc.) in the SELECT clause.
> If you want the result in a particular order use ORDER BY.
>
> -- 
> Bill Todd (TeamB) 
Technical Details
Message-ID: <45f25768@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <45f12ed6@newsgroups.borland.com> <45f17701$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,90802e9148f8740b
X-Google-Attributes: gid114a0e,public
X-Google-Language: LITHUANIAN,CP1257
From: "Darius Evseicikas" <dariuse@progmera.lt>
Newsgroups: borland.public.interbase.sql
References:  <45f12ed6@newsgroups.borland.com> <45f17701$1@newsgroups.borland.com>
Subject: Re: Pls help with procedure
Date: Sat, 10 Mar 2007 09:00:30 +0200
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 213.190.34.210
Message-ID: <45f25768@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1173509992 213.190.34.210 (9 Mar 2007 22:59:52 -0800)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail