{"id":88,"date":"2011-10-01T21:46:33","date_gmt":"2011-10-01T21:46:33","guid":{"rendered":"http:\/\/sql.programisius.lt\/?page_id=88"},"modified":"2011-10-02T13:56:12","modified_gmt":"2011-10-02T13:56:12","slug":"4-sugrupuotu-duomenu-atrinkimas","status":"publish","type":"page","link":"http:\/\/sql.programisius.lt\/?page_id=88","title":{"rendered":"4. Sugrupuot\u0173 duomen\u0173 atrinkimas"},"content":{"rendered":"<p>Sugrupuotiems duomenims atrinkimas gali b\u016bti daromas pasinaudojant HAVING. Jis yra GRUOP BY dalis, tiksliau papildo kaip papildomas vidinis atrikimo taisykli\u0173 rinkinys. HAVING strukt\u016bra:<\/p>\n<blockquote><p>SELECT stuleplisnr1, AVG(stulpelisnr2) FROM lenteles WHERE \u00a0\u201es\u0105lygosnr1\u201c GRUOP BY stulpeliai HAVING \u201es\u0105lygosnr2\u201c;<\/p><\/blockquote>\n<p>Atrinkime i\u0161 lentel\u0117s prek\u0117s pavadinim\u0105, kiek j\u0173 buvo u\u017esakyta (kiek\u012f) ir t\u0173, kuri\u0173 kiekis yra didesnis nei 1.<\/p>\n<blockquote><p>SELECT preke, COUNT(preke), kiekis FROM uzsakymu_sarasas WHERE kiekis &gt; 1 GROUP BY preke;<\/p><\/blockquote>\n<p><strong>U\u017eduotys<\/strong><\/p>\n<p>1. Kiek kuriame rajone yra klient\u0173?<br \/>\n2. I\u0161rinkite prek\u0117s pavadinim\u0105, did\u017eiausi\u0105 ir ma\u017eiausi\u0105 kainas, t\u0173 preki\u0173 kuri\u0173 did\u017eiausia kaina yra didesn\u0117 nei 190.00.<br \/>\n3. I\u0161rinkite klientus (stulpelis klientoid), kiek kart\u0173 pirko ir koki\u0105 sum\u0105 i\u0161leido (stulpelis kaina).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sugrupuotiems duomenims atrinkimas gali b\u016bti daromas pasinaudojant HAVING. Jis yra GRUOP BY dalis, tiksliau papildo kaip papildomas vidinis atrikimo taisykli\u0173 rinkinys. HAVING strukt\u016bra: SELECT stuleplisnr1, AVG(stulpelisnr2) FROM lenteles WHERE \u00a0\u201es\u0105lygosnr1\u201c GRUOP BY stulpeliai HAVING \u201es\u0105lygosnr2\u201c; Atrinkime i\u0161 lentel\u0117s prek\u0117s pavadinim\u0105, kiek j\u0173 buvo u\u017esakyta (kiek\u012f) ir t\u0173, kuri\u0173 kiekis yra didesnis nei 1. SELECT preke, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":13,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-88","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/88","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=88"}],"version-history":[{"count":3,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/88\/revisions"}],"predecessor-version":[{"id":90,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/88\/revisions\/90"}],"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=88"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}