Article View: borland.public.interbase.sql
Article #1021Re: Pls help with procedure
From: Darius Evseicikas
Date: Sat, 10 Mar 2007 07:00
Date: Sat, 10 Mar 2007 07:00
33 lines
2180 bytes
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-mailReferences:
<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