Article View: pl.comp.bazy-danych.msaccess
Article #137515Re: Liczenie mediany SQL - przyspieszenie
From: minfo
Date: Fri, 18 Aug 2017 08:02
Date: Fri, 18 Aug 2017 08:02
14 lines
1775 bytes
1775 bytes
> > > taka sugestia : > czy nie lepiej napisać kwerendę uprządkowaną rosnąco lub malejąco > policzyć rekordy > wyznaczyć środkowy > pobrać jego wartość > > md Niestety jest wiele produktów 1 do kilku tys i każdy ma po kilka kilkadziesiąt partii. W Excelu jest to trochę żmudne ... MF
Technical Details
Message-ID:
<ff847210-912d-4a66-b4ed-0f8c8d864773@googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder-in1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!f16no349120itb.0!news-out.google.com!i9ni18987qte.0!nntp.google.com!i19no176458qte.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mailReferences:
<4daf7bbf-74f5-4804-b5ec-a69ac0078248@googlegroups.com> <59969dc6$0$647$65785112@news.neostrada.pl>Show Full Headers
Complete Article Headers
X-Received: by 10.99.106.199 with SMTP id f190mr5574611pgc.202.1503043365639; Fri, 18 Aug 2017 01:02:45 -0700 (PDT) X-Received: by 10.31.158.141 with SMTP id h135mr14257vke.12.1503043365525; Fri, 18 Aug 2017 01:02:45 -0700 (PDT) Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder-in1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!f16no349120itb.0!news-out.google.com!i9ni18987qte.0!nntp.google.com!i19no176458qte.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: pl.comp.bazy-danych.msaccess Date: Fri, 18 Aug 2017 01:02:45 -0700 (PDT) In-Reply-To: <59969dc6$0$647$65785112@news.neostrada.pl> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=213.241.94.194; posting-account=vYGi6woAAAA6NlWlzOm2dBNZ6sPJDKfx NNTP-Posting-Host: 213.241.94.194 References: <4daf7bbf-74f5-4804-b5ec-a69ac0078248@googlegroups.com> <59969dc6$0$647$65785112@news.neostrada.pl> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <ff847210-912d-4a66-b4ed-0f8c8d864773@googlegroups.com> Subject: Re: Liczenie mediany SQL - przyspieszenie From: minfo@onet.pl Injection-Date: Fri, 18 Aug 2017 08:02:45 +0000 Lines: 14 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit