Re: sql: group by

Article View: be.comp.programming

Article #13823

Back to be.comp.programming Previous Next

#13823

From: Bart Vandewoestyne
Date: Sun, 27 May 2001 16:00

21 lines
2045 bytes

Bart Vandewoestyne wrote:
> 
> Nu is mijn vraag: waarom moet die PNAME ook nog in de GROUP BY
> clause?  Als ik ze per project wil, dan zou ik redeneren dat groeperen
> op projectnummer (PNUMBER) voldoende is?  Ik snap niet waarom die
> PNAME er dan ook nog bij moet.

Ik denk dat dit er wel mee te maken heeft, maar ik snap niet goed
waarm het zo moet:

http://www.sqlcourse2.com/groupby-1.html

Greetzzz,
mc303

-- 
Ing. Bart Vandewoestyne			 Bart.Vandewoestyne@pandora.be
Hugo Verrieststraat 48			       GSM: +32 (0)478 397 697
B-8550 Zwevegem			 http://users.pandora.be/vandewoestyne
----------------------------------------------------------------------
"Any fool can know, the point is to understand." - Albert Einstein

Technical Details

Message-ID: <3B11249F.7CBECB0D@pandora.be>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!logbridge.uoregon.edu!news.maxwell.syr.edu!news-ge.switch.ch!naxos.belnet.be!news.belnet.be!not-for-mail

References: <3B11229E.9335CC19@pandora.be>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: fcea4,91d94af356f134d1
X-Google-Attributes: gidfcea4,public
X-Google-Thread: 1147fd,1494a4b4138eb4af,start
X-Google-Attributes: gid1147fd,public
X-Google-ArrivalTime: 2001-05-27 09:02:09 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!logbridge.uoregon.edu!news.maxwell.syr.edu!news-ge.switch.ch!naxos.belnet.be!news.belnet.be!not-for-mail
From: Bart Vandewoestyne <Bart.Vandewoestyne@pandora.be>
Newsgroups: be.comp.programming,kotnet.comp.programmeren
Subject: Re: sql: group by
Date: Sun, 27 May 2001 18:00:31 +0200
Organization: MyHome
Lines: 21
Message-ID: <3B11249F.7CBECB0D@pandora.be>
References: <3B11229E.9335CC19@pandora.be>
NNTP-Posting-Host: seven.kulnet.kuleuven.ac.be
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: naxos.belnet.be 990979270 29758 134.58.127.12 (27 May 2001 16:01:10 GMT)
X-Complaints-To: abuse@belnet.be
NNTP-Posting-Date: Sun, 27 May 2001 16:01:10 +0000 (UTC)
X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.5 i686)
X-Accept-Language: nl-BE, nl, en, de
Cache-Post-Path: seven.kulnet.kuleuven.ac.be!unknown@kn-10-0-53-046.kotnet.kuleuven.ac.be
X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/)

Reply to Parent Message