Re: Pls help with procedure

Article View: borland.public.interbase.sql

Article #1020

Back to borland.public.interbase.sql Previous Next

#1020

From: Bill Todd
Date: Fri, 09 Mar 2007 15:02

11 lines
1245 bytes

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: <45f17701$1@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>

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>
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: <45f17701$1@newsgroups.borland.com>
Date: 9 Mar 2007 07:02:25 -0800
X-Trace: newsgroups.borland.com 1173452545 216.207.211.19 (9 Mar 2007 07:02:25 -0800)
Lines: 11
X-Authenticated-User: btodd
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

Reply to Parent Message