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 01.06.2016 20:00
dex Van mreze
Super Moderator
Registrovan od:23.02.2012
Lokacija:Knjazevac


Predmet:Re: Pretvaranje horizontalnog niza u vertikalni
PreuzmiIzvorni kôd (SQL):
  1. SELECT Sifra, 'M' AS Velicina, M AS BrojKomada
  2. FROM NazivTvojeTabele
  3. UNION SELECT Sifra, 'S', S
  4. FROM NazivTvojeTabele
  5. UNION SELECT Sifra, 'L', L
  6. FROM NazivTvojeTabele;