{"id":86,"date":"2011-10-01T21:17:49","date_gmt":"2011-10-01T21:17:49","guid":{"rendered":"http:\/\/sql.programisius.lt\/?page_id=86"},"modified":"2011-10-01T21:17:49","modified_gmt":"2011-10-01T21:17:49","slug":"3-duomenu-grupavimas","status":"publish","type":"page","link":"http:\/\/sql.programisius.lt\/?page_id=86","title":{"rendered":"3. Duomen\u0173 grupavimas"},"content":{"rendered":"<p>U\u017eklausoje eilu\u010di\u0173 grupavimas atliekama su GROUP BY pagal<br \/>\npasirinktus stulpelius. Sugrupuotiems stulpeliams galima \u012fvykdyti sankaupos<br \/>\nfunkcijas. GRUOP BY strukt\u016brinis pavyzdys:<\/p>\n<blockquote><p>SELECT stuleplisnr1, SUM(stulpelisnr2) FROM lentele GRUOP BY<br \/>\nstulpelisnr1;<\/p>\n<p>SELECT stuleplisnr1, SUM(stulpelisnr2) FROM lentele GRUOP BY<br \/>\nstulpelisnr1, stulpelisn2;<\/p><\/blockquote>\n<p>Pavyzd\u017eiui, norim, kad b\u016bt\u0173 sugrupuotos visos prek\u0117s<br \/>\nlentel\u0117je pagal prek\u0117s pavadinim\u0105,\u00a0 o kitame<br \/>\nstulpelyje b\u016bt\u0173 pateikta did\u017eiausia tos prek\u0117s pardavimo kaina, o parduot\u0173<br \/>\npreki\u0173 kurias analizuotume b\u016bt\u0173 daugiau nei 1. SQL komanda b\u016bt\u0173:<\/p>\n<blockquote><p>SELECT preke, MAX(kaina) FROM uzsakymu_sarasas WHERE kiekis &gt; 1\u00a0 GROUP BY preke;<\/p><\/blockquote>\n<p><strong>U\u017eduotys<\/strong><\/p>\n<p>1. Kiek klient\u0173 yra i\u0161 skirting\u0173 rajon\u0173? I\u0161rinkite rajonus ir koks skai\u010dius klient\u0173 yra i\u0161 j\u0173 (COUNT pad\u0117s suskai\u010diuoti; lentel\u0117: klientai)<br \/>\n2. I\u0161rinkite skirtingas prekes ir did\u017eiausi\u0105 bei ma\u017eiausia jos kaina. (lentel\u0117 uzsakymu_sarasas)<br \/>\n3. Kiek u\u017esakym\u0173 padar\u0117 skirtingi klientai? (lentel\u0117 uzsakymu_sarasas)<br \/>\n4. Sugalvoti dar 3 SQL u\u017eklausas ir jas \u012fvykdyti (lentel\u0117se ir uzsakymu_sarasas,<br \/>\nir\u00a0 klientai)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>U\u017eklausoje eilu\u010di\u0173 grupavimas atliekama su GROUP BY pagal pasirinktus stulpelius. Sugrupuotiems stulpeliams galima \u012fvykdyti sankaupos funkcijas. GRUOP BY strukt\u016brinis pavyzdys: SELECT stuleplisnr1, SUM(stulpelisnr2) FROM lentele GRUOP BY stulpelisnr1; SELECT stuleplisnr1, SUM(stulpelisnr2) FROM lentele GRUOP BY stulpelisnr1, stulpelisn2; Pavyzd\u017eiui, norim, kad b\u016bt\u0173 sugrupuotos visos prek\u0117s lentel\u0117je pagal prek\u0117s pavadinim\u0105,\u00a0 o kitame stulpelyje b\u016bt\u0173 pateikta did\u017eiausia tos [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":13,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-86","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/86","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=86"}],"version-history":[{"count":1,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/86\/revisions"}],"predecessor-version":[{"id":87,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/86\/revisions\/87"}],"up":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/13"}],"wp:attachment":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=86"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}