Warning: A non-numeric value encountered in /home2/icentarb/public_html/icentar/classes/class.permissions.php on line 101

Warning: filesystem::file_put_contents(data/session_del.php): failed to open stream: Permission denied in /home2/icentarb/public_html/icentar/classes/class.filesystem.php on line 142
iCentar
Prikazi cijelu temu 22.06.2016 16:19
dex Van mreze
Super Moderator
Registrovan od:23.02.2012
Lokacija:Knjazevac


Predmet:Re: Pretvaranje horizontalnog niza u vertikalni
Pogledaj i poigraj se malo sa Crosstab Query

PreuzmiIzvorni kôd (SQL):
  1. TRANSFORM SUM(BrojKomada) AS Komada
  2. SELECT Sifra
  3. FROM ZbirnaTab
  4. GROUP BY Sifra
  5. PIVOT Velicina;