{"id":156,"date":"2011-10-02T13:55:25","date_gmt":"2011-10-02T13:55:25","guid":{"rendered":"http:\/\/sql.programisius.lt\/?page_id=156"},"modified":"2011-10-02T13:55:25","modified_gmt":"2011-10-02T13:55:25","slug":"4-sugrupuotu-duomenu-atrinkimas","status":"publish","type":"page","link":"http:\/\/sql.programisius.lt\/?page_id=156","title":{"rendered":"4. Sugrupuot\u0173 duomen\u0173 atrinkimas"},"content":{"rendered":"<p>1.<\/p>\n<blockquote><p>SELECT\u00a0 rajonas, COUNT(*) FROM klientai GROUP BY rajonas;<\/p><\/blockquote>\n<p>2.<\/p>\n<blockquote><p>SELECT\u00a0 preke, MIN(kaina), MAX(kaina) FROM uzsakymu_sarasas WHERE kaina&gt;190.00 GROUP BY kaina;<\/p><\/blockquote>\n<p>3.<\/p>\n<blockquote><p>SELECT\u00a0 klientoid, COUNT(*),\u00a0 SUM(kaina) FROM uzsakymu_sarasas\u00a0 GROUP BY kaina ;<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>1. SELECT\u00a0 rajonas, COUNT(*) FROM klientai GROUP BY rajonas; 2. SELECT\u00a0 preke, MIN(kaina), MAX(kaina) FROM uzsakymu_sarasas WHERE kaina&gt;190.00 GROUP BY kaina; 3. SELECT\u00a0 klientoid, COUNT(*),\u00a0 SUM(kaina) FROM uzsakymu_sarasas\u00a0 GROUP BY kaina ;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":117,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-156","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/156","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=156"}],"version-history":[{"count":2,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/156\/revisions"}],"predecessor-version":[{"id":158,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/156\/revisions\/158"}],"up":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/117"}],"wp:attachment":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}