Re: Pls help with procedure

Article View: borland.public.interbase.sql

Article #1023

Back to borland.public.interbase.sql Previous Next

#1023

From: Bill Todd
Date: Sat, 10 Mar 2007 15:10

9 lines
1228 bytes

Darius Evseicikas wrote:

> If I don't use the group I select all records, but I need only
> grouped records by objektas, year, month

Either use Harun's suggestion or add COUNT(*) to the SELECT clause.

-- 
Bill Todd (TeamB)

Technical Details

Message-ID: <45f2ca82$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <45f12ed6@newsgroups.borland.com> <45f17701$1@newsgroups.borland.com> <45f25768@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,90802e9148f8740b
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: Pls help with procedure
Newsgroups: borland.public.interbase.sql
References: <45f12ed6@newsgroups.borland.com> <45f17701$1@newsgroups.borland.com> <45f25768@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.6
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 216.207.211.19
Message-ID: <45f2ca82$1@newsgroups.borland.com>
Date: 10 Mar 2007 07:10:58 -0800
X-Trace: newsgroups.borland.com 1173539458 216.207.211.19 (10 Mar 2007 07:10:58 -0800)
Lines: 9
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message