Re: query vraagje

Article View: be.comp.programming

Article #5273

Back to be.comp.programming Previous Next

#5273

From: Gunter Schelfhout
Date: Sat, 17 May 2003 13:59

20 lines
1619 bytes

drukqs wrote:

> Hoi
> 
> Ik zou de artikelen die het meest voorkomen moeten sorteren. Dus artikel1
> komt 10 keer voor => staat bovenaan. Artikel5 komt 9 keer voor => staat
> 2e. je begrijpt het wel. Dit is wat ik heb
> 
> select max(count(artikelnr))
> from artikels
> group by artikelnr
> 

SELECT artikelnr, count(artikelnr) AS stock
FROM artikels
GROUP BY artikelnr
ORDER BY stock DESC

-- 
Blood, sweat & tears

Technical Details

Message-ID: <Verxa.6257$1u5.430@afrodite.telenet-ops.be>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news-out.visi.com!petbe.visi.com!feed2.newsreader.com!newsreader.com!newshosting.com!news-xfer2.atl.newshosting.com!newsfeed.kabelfoon.nl!212.113.2.136.MISMATCH!newsfeed.london1.eu.level3.net!level3eu!ossa.telenet-ops.be!afrodite.telenet-ops.be.POSTED!not-for-mail

References: <Xns937EA009C534Dinvaliddrukqspandora@195.130.132.69>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: fcea4,7cc58b16cfeef2a9
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2003-05-17 06:59:33 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news-out.visi.com!petbe.visi.com!feed2.newsreader.com!newsreader.com!newshosting.com!news-xfer2.atl.newshosting.com!newsfeed.kabelfoon.nl!212.113.2.136.MISMATCH!newsfeed.london1.eu.level3.net!level3eu!ossa.telenet-ops.be!afrodite.telenet-ops.be.POSTED!not-for-mail
From: Gunter Schelfhout <nospam@please.com>
Subject: Re: query vraagje
Newsgroups: be.comp.programming
References: <Xns937EA009C534Dinvaliddrukqspandora@195.130.132.69>
Lines: 20
User-Agent: KNode/0.7.1
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
Message-ID: <Verxa.6257$1u5.430@afrodite.telenet-ops.be>
Date: Sat, 17 May 2003 13:59:17 GMT
NNTP-Posting-Host: 213.118.153.61
X-Complaints-To: abuse@telenet.be
X-Trace: afrodite.telenet-ops.be 1053179957 213.118.153.61 (Sat, 17 May 2003 15:59:17 MET DST)
NNTP-Posting-Date: Sat, 17 May 2003 15:59:17 MET DST
Organization: Telenet Internet

Reply to Parent Message