Re: SQL

Article View: pl.comp.lang.delphi.bazy-danych

Article #82837

Back to pl.comp.lang.delphi.bazy-danych Previous Next

#82837

From: konsul41
Date: Thu, 03 Aug 2017 09:38

13 lines
1541 bytes

Działa to
SELECT *
   FROM
     crosstab( 'SELECT 57::numeric AS id_srodektrwaly, 
generate_series::numeric,coalesce(miesodpis::numeric,0)
   FROM generate_series(1,12)
   LEFT JOIN (select miesiac::numeric,id_srodektrwaly::numeric, 
miesodpis::numeric from planamortyzacji where rok=''2017'' and 
id_srodektrwaly=57)AS plan ON plan.miesiac =generate_series')
     AS final_result(id_srodektrwaly numeric,m01 numeric,m02 numeric,m03 
numeric,m04 numeric,m05 numeric,m06 numeric,m07 numeric,m08 numeric,m09 
numeric,m10 numeric,m11 numeric,m12 numeric)
    ;

Technical Details

Message-ID: <oluqvi$fnn$1@portraits.wsisiz.edu.pl>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!wsisiz.edu.pl!.POSTED.jue163.internetdsl.tpnet.pl!not-for-mail

References: <olulek$bh3$1@portraits.wsisiz.edu.pl> <olup48$ebf$1@portraits.wsisiz.edu.pl> <oluq67$f6a$1@portraits.wsisiz.edu.pl>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!wsisiz.edu.pl!.POSTED.jue163.internetdsl.tpnet.pl!not-for-mail
From: "konsul41@wp.pl" <konsul41@wp.pl>
Newsgroups: pl.comp.lang.delphi.bazy-danych
Subject: Re: SQL
Date: Thu, 3 Aug 2017 11:38:58 +0200
Organization: http://www.wit.edu.pl
Message-ID: <oluqvi$fnn$1@portraits.wsisiz.edu.pl>
References: <olulek$bh3$1@portraits.wsisiz.edu.pl> <olup48$ebf$1@portraits.wsisiz.edu.pl> <oluq67$f6a$1@portraits.wsisiz.edu.pl>
Mime-Version: 1.0
Injection-Date: Thu, 3 Aug 2017 09:38:58 -0000 (UTC)
Injection-Info: portraits.wsisiz.edu.pl; posting-host="jue163.internetdsl.tpnet.pl:95.48.160.163"; logging-data="16119"; mail-complaints-to="abuse@wsisiz.edu.pl"
User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:52.0) Gecko/20100101 Thunderbird/52.2.1
In-Reply-To: <oluq67$f6a$1@portraits.wsisiz.edu.pl>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message