{"id":82,"date":"2011-10-01T19:57:12","date_gmt":"2011-10-01T19:57:12","guid":{"rendered":"http:\/\/sql.programisius.lt\/?page_id=82"},"modified":"2011-10-01T19:57:26","modified_gmt":"2011-10-01T19:57:26","slug":"2-sankaupos-funkcijos","status":"publish","type":"page","link":"http:\/\/sql.programisius.lt\/?page_id=82","title":{"rendered":"2. Sankaupos funkcijos"},"content":{"rendered":"

MIN<\/span> \u2013 gra\u017eina ma\u017eiausios vert\u0117s pagal stulpel\u012f eilut\u0119
\nMAX<\/span> \u2013 gra\u017eina did\u017eiausios vert\u0117s pagal stulpel\u012f eilut\u0119
\nSUM<\/span> \u2013 gra\u017eina sum\u0105 pagal stulpelius i\u0161 atrinkt\u0173 eilu\u010di\u0173
\nAVG<\/span> \u2013 gra\u017eina vidutin\u0119 vert\u0119 pagal stulpelius i\u0161 atrinkt\u0173 eilu\u010di\u0173
\nCOUNT<\/span> \u2013 gra\u017eina kiek\u012f ver\u010di\u0173 pagal atrinktus stulpelius (sugrupuotas eilutes)
\nCOUNT(*)<\/span> \u2013 gra\u017eina kiek\u012f ver\u010di\u0173 pagal atrinktas eilutes<\/p>\n

Pavyzd\u017eiui su lentele \u201eskaiciai\u201c<\/p>\n\n\n\n\n\n\n\n\n
\n

SK1<\/strong><\/p>\n<\/td>\n

\n

SK2<\/strong><\/p>\n<\/td>\n

\n

SKAICIUS<\/strong><\/p>\n<\/td>\n<\/tr>\n

\n

1<\/p>\n<\/td>\n

\n

I<\/p>\n<\/td>\n

\n

Vienas<\/p>\n<\/td>\n<\/tr>\n

\n

1<\/p>\n<\/td>\n

\n

I<\/p>\n<\/td>\n

\n

Vienas<\/p>\n<\/td>\n<\/tr>\n

\n

2<\/p>\n<\/td>\n

\n

II<\/p>\n<\/td>\n

\n

Du<\/p>\n<\/td>\n<\/tr>\n

\n

3<\/p>\n<\/td>\n

\n

III<\/p>\n<\/td>\n

\n

Trys<\/p>\n<\/td>\n<\/tr>\n

\n

4<\/p>\n<\/td>\n

\n

IV<\/p>\n<\/td>\n

\n

Keturi<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

SQL sumos komanda:<\/p>\n

SELECT SUM(SK1) FROM skai\u010diai;<\/p><\/blockquote>\n\n\n\n\n
\n

SUM(SK1)<\/strong><\/p>\n<\/td>\n<\/tr>\n

\n

11<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Eilu\u010di\u0173 skai\u010dius:<\/p>\n

SELECT COUNT(*) FROM skai\u010diai;<\/p><\/blockquote>\n\n\n\n\n
\n

COUNT(*)<\/strong><\/p>\n<\/td>\n<\/tr>\n

\n

5<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Sankaupos funkcij\u0173 u\u017eduotys<\/strong><\/p>\n

1. I\u0161rinkite did\u017eiausi\u0105 kain\u0105 u\u017e kuri\u0105 buvo nupirkta prek\u0117.
\n2. I\u0161rinkite vidutin\u0119 kain\u0105 u\u017e kuri\u0105 buvo perkama gruod\u017eio m\u0117nes\u012f.
\n3. Kiek yra eilu\u010di\u0173 lentel\u0117je?
\n4. Kokia yra ma\u017eiausia kaina u\u017e kuri\u0105 buvo nupirkta palapin\u0117?
\n5. Sugalvokite dar 3 SQL u\u017eklasas, kuriose panaudotum\u0117te sankaupos funkcijas.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

MIN \u2013 gra\u017eina ma\u017eiausios vert\u0117s pagal stulpel\u012f eilut\u0119 MAX \u2013 gra\u017eina did\u017eiausios vert\u0117s pagal stulpel\u012f eilut\u0119 SUM \u2013 gra\u017eina sum\u0105 pagal stulpelius i\u0161 atrinkt\u0173 eilu\u010di\u0173 AVG \u2013 gra\u017eina vidutin\u0119 vert\u0119 pagal stulpelius i\u0161 atrinkt\u0173 eilu\u010di\u0173 COUNT \u2013 gra\u017eina kiek\u012f ver\u010di\u0173 pagal atrinktus stulpelius (sugrupuotas eilutes) COUNT(*) \u2013 gra\u017eina kiek\u012f ver\u010di\u0173 pagal atrinktas eilutes Pavyzd\u017eiui su […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":13,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-82","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/82","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=82"}],"version-history":[{"count":2,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/82\/revisions"}],"predecessor-version":[{"id":84,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/82\/revisions\/84"}],"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=82"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}