na as priejau tokio sprendimo SELECT Part_kodas, Part_Pavad, SUM(Preklik_su_pvm) AS Viso ,S20404 = SUM( CASE WHEN sandelis= '20404' THEN Preklik_su_pvm ELSE 0 END ) ,S20405 = SUM( CASE WHEN sandelis= '20405' THEN Preklik_su_pvm ELSE 0 END ) ,S20406 = SUM( CASE WHEN sandelis= '20406' THEN Preklik_su_pvm ELSE 0 END ) ,S20411 = SUM(CASE WHEN sandelis= '20411' THEN Preklik_su_pvm ELSE 0 END ) ,S20413 = SUM( CASE WHEN sandelis= '20413' THEN Preklik_su_pvm ELSE 0 END ) ,S20414 = SUM( CASE WHEN sandelis= '20414' THEN Preklik_su_pvm ELSE 0 END ) FROM preklik_sumine GROUP BY Part_kodas, Part_Pavad bet gal yra koks paprastesnis ??? "paliava" <paliava@interneka_tratata.lt> wrote in message news:euq9kp$pl0$1@trimpas.omnitel.net... > pasiimi knyga eskūelas čeinykams atsiverti ties "group by" ir padarai. > > "Vytautas" <top@secret.com> wrote in message news:euq93u$ol4$1@trimpas.omnitel.net... >> ar galima padaryt toki selecta: >> >> turim lentele: >> Partneris Likutis Sandelis >> >> is jos reikai gaut toke forma... >> Partneris Likutis_sandlija_nr1 Likutis_sandelija_nr2 Likutis_sandelija_nr3 ir t.t. ..... >> >> ar taip imanoma padaryt Sql'e ???